Page 1 of 2

Moving database to new driver

PostPosted: Wed Oct 08, 2008 8:51 pm
by Ramjet
I have PostgreSQL installed on my main C driver which however only has a few GB left of space. So I wanted to know if it is possible to have the databases that take up all the space on my D driver. I found this topic http://www.pokertracker.com/forums/viewtopic.php?f=17&t=526 which shows how to create a db on a different driver. But how could I move my database from driver C to driver D?

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 4:03 am
by WhiteRider

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 5:31 am
by Ramjet
Hello WR,

When I click on the post it says that I am not authorized to view that forum.

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 7:21 am
by WhiteRider
Sorry - I just realised that..
I'll get you the info.

Hi guys, bought myself a new velociraptor, and am trying it out.

Originally, i had a C drive, and a 500gig E drive, which had pt3, hem, and postgres on it.

Now, i have a 300gig drive, which is the F drive.

I want to put everything from the E drive (only 160gig used, not the full 500) onto the F drive, and then use that.

My problem is this. Drive clone didnt really want to do it properly, so i just copied and pasted all of the folders from the E to the F drive

PT3 and the other programs load properly, but postgres doesnt!

Pt 3 loads ok, but then it will not connect to the db. I get the red unable to login to db. REeason could not connect to server connection refused 0x00000274d/10061 is the server runnin on host localhost and accepting tcp/ip connecttion on port 5432


Any ideas on what i can do? I really dont want to reimport 20 million hands!



When i tried to remove the postgres password, and edit the hba.conf file, notepad opens, and says the system cannot find the path specified.

I assume that postgres is looking for my E drive, which is unplugged atm,

How can i get postgres to look for everything that is present on my new speedy velociraptor drive F, instead of the old one on E?

All help much appreciated,and when i get this sorted out, i can give everyone a comparison of the old and new speedy drive!



go in services management. edit the postgresql service, change the references to E:\ to F:\ - this will be where to find the pg_ctl.exe command, the bin folder and the data folder.

If you do this properly, postgres will work again after a reboot.

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 5:28 pm
by Ramjet
WhiteRider wrote:
go in services management. edit the postgresql service, change the references to E:\ to F:\ - this will be where to find the pg_ctl.exe command, the bin folder and the data folder.

If you do this properly, postgres will work again after a reboot.


Can't follow this step very well. Where do I find services management and how can I edit the postgresql reference from C to D???

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 5:57 pm
by WhiteRider
I guess they mean Start -> Control Panel -> Administrative Tools -> Services; find postgres and right click -> Properties.

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 6:08 pm
by Ramjet
I got to the point where I select PostgreSQL Database from the services list and then click on Properties. I then see the reference to the old C drive, however I cannot change it to the new D drive as it is written in a gray box and not a white one. Anyone know how I can change the reference?

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 6:16 pm
by WhiteRider
Did you stop the service? I don't think you'll be able to change it while it's running.

Re: Moving database to new driver

PostPosted: Thu Oct 09, 2008 7:10 pm
by Ramjet
I can't change the reference of any service. When i go on the properties of the services its always in a box which you can't edit.

Re: Moving database to new driver

PostPosted: Fri Oct 10, 2008 3:47 am
by WhiteRider
You will need to stop the postgres service before you can change anything - I that's on the right click menu too.

highfalutin