PDA

View Full Version : Moving Postgres Folder



Jagsti
12-25-2008, 04:15 PM
I would like to move my Postgres folder from my C: drive to my D: drive as it's getting a little too big and I need the space on the C: drive. When I move the folder and open up HEM it says it cant locate it saying 'failed to establish a connection to 127.0.0.1' How do I change this to the new location, also how do I know what the address is of the new location, or is this just not possible?

Thanks

Jagsti
12-25-2008, 10:25 PM
Ok looks like I've completely butchered this job. One thing has lead to another and I've reloaded PostgresSQL but I cant seem to get the server to listen or anything now when I go in to the pgadmin.

morny
12-26-2008, 11:21 AM
You cant just move the PostgreSQL folder, theres links on the main drive to files on the old drive and postgreSQL wont be able to find them.

To do it properly try this http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12

Thats quicker but dosent always work and if it dosent then try this method http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

Jagsti
12-26-2008, 03:08 PM
ok, I think this is probably a lost cause. But After all the previous moving/deleting/reinstalling, I have now got a new database, don't know where the old one is. The PGAdmin3 shows there are 2 databases, but I cant connect to the other one.

Prior to all the movements, I saved the directory 'Data' which I presume holds all the main data for HEM, but the new database doesn't show the hands.

I take it there's no easy solution, if any, to somehow get my new database to recognise the old 'Data' folder?

morny
12-27-2008, 10:46 AM
You see when you setup a new blank data folder you cant just paste another data folder to that folder so the easiest way would be to export the current HH from the new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 turn off the service by finding PostgreSQL in the Start Menu and using the Stop Service option. Then delete the \Data folder in the new installation of postgres and copy your backed up \Data folder over. if you can't delete then you may need to reboot.

Then in the PostgreSQL menu click on Start Service and if everything went right you should be able to connect to your old database. Then youll just need to import the new HH into this database if it works. Problem is this isnt the ideal way to do this so it dosent always work which is why you should do it the way i mentioned in the above thread