Обсуждение: Filesystem Backup

On Monday, February 4, 2002, at 12:54  AM, manav wrote:


<excerpt><fontfamily><param>Arial</param><smaller>Hello All,</smaller></fontfamily>


<fontfamily><param>Arial</param><smaller> </smaller></fontfamily>


<fontfamily><param>Arial</param><smaller>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...)</smaller></fontfamily>


<fontfamily><param>Arial</param><smaller>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'.</smaller></fontfamily>


</excerpt>

What version of PostgreSQL do you have installed? Is it the same
version as the data directory that you backed up?


I had the problem once when I was experimenting with a different
filesystem that I messed up the ownership/perms of the data directory.

Is it owned by the user that postmaster runs as? (pgsql or postgres
depending on distribution)



<fontfamily><param>Helvetica</param>==============================

David Stanaway

Personal: david@stanaway.net

Work: david@netventures.com.au</fontfamily>On Monday, February 4, 2002, at 12:54  AM, 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'.
>

What version of PostgreSQL do you have installed? Is it the same version
as the data directory that you backed up?

I had the problem once when I was experimenting with a different
filesystem that I messed up the ownership/perms of the data directory.
Is it owned by the user that postmaster runs as? (pgsql or postgres
depending on distribution)


==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au

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
602-604-3100  ext 242

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--
>