Re: Can I substitute a recovered /data directory into a new installation? - Mailing list pgsql-admin

From David J. Fenske
Subject Re: Can I substitute a recovered /data directory into a new installation?
Date
Msg-id 9E5982E7FA90424D8255B482D11D43930EBBB1@KUDZU.nhb.local
Whole thread Raw
In response to Re: Can I substitute a recovered /data directory into a new installation?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
That was exactly it. Doh! After I made all the subdirectories 700,
adding the traverse directory permission, it fired right up. Thanks Tom!


Thanks, David

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, November 07, 2006 4:26 PM
To: David J. Fenske
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Can I substitute a recovered /data directory into a
new installation?

"David J. Fenske" <davidf@nhb.org> writes:
> ... I have reset all file owner and
> groups to the postgres user, and used chmod to give just the postgres
> user rw permission (600, oh and 700 on the data directory itself).

If you mean you made all the sub-directories mode 600, that would be
your problem ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: synonyms like in oracle?
Next
From: Jeff Frost
Date:
Subject: statistics buffer is full