PDA

View Full Version : How to import the old "data" folder from postgres



hem2dude
03-06-2011, 11:15 AM
Hi!

I got the "127.0.0.1 cannot connect problem" that so many seems to have. So I uninstalled postgres and reinstalled version 8.3.9 with the FAQ "Reinstall PostgreSQL Preserving Old Database".

However I missed the step to unselect the "Initalize database cluster" so now I got a new database.

I don't have a Holdem Manager backup but I have saved the "data" folder of postgres.

1. Is it possible to import the old database from the "data" folder somehow?
2. Or do I have to uninstall och reinstall everything again following the guide?
3. Other tips?

Thanks!

Sarek
03-06-2011, 04:33 PM
The only way to use old data folder is to install the same Postgres version and set this old folder as database cluster.
If it was 8.3 - install 8.3
if 8.4 - install 8.4 too

hem2dude
03-06-2011, 07:23 PM
Do I have to put the data folder in some special folder on the computer or can I have it placed anyway?


The only way to use old data folder is to install the same Postgres version and set this old folder as database cluster.
If it was 8.3 - install 8.3
if 8.4 - install 8.4 too

Patvs
03-06-2011, 09:54 PM
Manually add exceptions to the windows firewall for pg_ctl.exe, postgres.exe and port 5432, also for holdemmanager.exe and hmhud.exe

Copy the data folder back to the same location.
Reinstall SQL to that location, and it should detect the old data folder.
If it doesn't, create a new empty database.


Default folder for the data folder is: C:/Program Files/PostgreSQL/8.x/data