restoring postgresql database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rhaynes
Forum Newbie
Posts: 18
Joined: Mon Nov 08, 2004 8:32 am

restoring postgresql database

Post 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
Post Reply