Re: Filesystem Backup

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