restoring postgresql database
Posted: Mon Mar 13, 2006 9:59 pm
Hi, I had a catastrophic hard disk failure. Unfortunately, my last pg_dumpall didn't survive. I do, however, have
all the data from /var/lib/pgsql etc... from hourly backups.
What is the best way to recover. I assume I will have to create the user again... will restoring the files to /var/lib/pgsql from backup work after creating the the postgresql user? I realize there is the potential of inconsistent data. Anything else to watch for??
Thanks,
R Haynes
all the data from /var/lib/pgsql etc... from hourly backups.
What is the best way to recover. I assume I will have to create the user again... will restoring the files to /var/lib/pgsql from backup work after creating the the postgresql user? I realize there is the potential of inconsistent data. Anything else to watch for??
Thanks,
R Haynes