Moving database to new driver

[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?

[WhiteRider]

Have a look at this post:
viewtopic.php?f=2&t=12754&p=59659#p59567

[Ramjet]

Hello WR,

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

[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.

[Ramjet]

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???

[WhiteRider]

I guess they mean Start -> Control Panel -> Administrative Tools -> Services; find postgres and right click -> Properties.

[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?

[WhiteRider]

Did you stop the service? I don't think you'll be able to change it while it's running.

[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.

[WhiteRider]

You will need to stop the postgres service before you can change anything - I that's on the right click menu too.