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: