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