Re: Filesystem Backup - Mailing list pgsql-admin

From manav
Subject Re: Filesystem Backup
Date
Msg-id 000501c1addc$14a14c10$1101a8c0@cp335088a
Whole thread Raw
In response to Filesystem Backup  ("manav" <manav@glue.umd.edu>)
List pgsql-admin
Well the pg_dump(all) utils give a version mismatch, I guess my DB is
7.1.3 and the utils are some other version (how do I check the versions
correctly?) dunno how that happened. How can I upgrade the utils and
leave the DB engine untouched? It's a redhat linux box so rpms would be
preferrd.

Thanks for the response, and yes I made sure the server went down before
I did the fs backup.

sonny

"Naomi Walker" <nwalker@eldocomp.com> wrote in message
news:<4.2.2.20020204092555.00abeac0@ecint.ecinet.com>...
> --=====================_405291708==_.ALT
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
>
> 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
> --=====================_405291708==_.ALT
> Content-Type: text/html; charset="us-ascii"
>
> <html>
> <br>
> 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.  <br>
> <br> If you were doing this for some other reason, this might not
> pertain.  What started this adventure?<br>
> <br>
> At 08:54 AM 2/3/02 -0500, manav wrote:<br>
> <br>
> <font face="arial" size=2><blockquote type=cite cite>Hello All,<br>
> </font><br>
>  <br>
> <br>
> 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...) <br>
> <br>
> 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'.<br>
> <br>
>  <br>
> <br>
> Am I missing something? are there any other steps to a filesystem
> backup?<br>
> <br>
>  <br>
> <br>
> -sonny</blockquote><br>
> <div>--</div>
> <div>Naomi Walker</div>
> <div>Chief Information Officer</div>
> <div>Eldorado Computing, Inc.</div>
> 602-604-3100  ext 242
> </html>
>
> --=====================_405291708==_.ALT--
>



pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Re: Filesystem Backup
Next
From: "sreedhar"
Date:
Subject: how can I retreive Users,Groups and Permissions