If I understand correctly, the only time a pure file system restore would work to put back your data was if the instance was down when the file systems were backed up. Otherwise, pg_dump of a database, or pg_dumpall of the whole instance would be necessary.
If you were doing this for some other reason, this might not pertain. What started this adventure?
At 08:54 AM 2/3/02 -0500, manav wrote:
Hello All,
I am in a fix and need help. I am reinstalling postgresql server on my linux workstation and\ I did a filesystem backup of ../pgsql/data/*, but when I deleted the data directory and reconstructed it from my backup (without the reinstall, just to check if things would work) I started seeing errors (I mv' the data directory twice...)
The first error was "postmaster.opt.default not found in ../pgsql/data/postmaster.opt.default' and when I created an empty file it said '../pgsql/data/base/template1/pg_class not found'.
Am I missing something? are there any other steps to a filesystem backup?
-sonny
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242