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