Page 1 of 1

restoring postgresql database

Posted: Mon Mar 13, 2006 9:59 pm
by rhaynes
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