| From: | "manav" <manav(at)glue(dot)umd(dot)edu> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Filesystem Backup |
| Date: | 2002-02-05 00:28:44 |
| Message-ID: | 000501c1addc$14a14c10$1101a8c0@cp335088a |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)eldocomp(dot)com> wrote in message
news:<4(dot)2(dot)2(dot)20020204092555(dot)00abeac0(at)ecint(dot)ecinet(dot)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--
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sreedhar | 2002-02-05 04:32:45 | how can I retreive Users,Groups and Permissions |
| Previous Message | Naomi Walker | 2002-02-04 16:28:47 | Re: Filesystem Backup |