Re: Can I substitute a recovered /data directory into a new installation?

From: "David J(dot) Fenske" <davidf(at)nhb(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Can I substitute a recovered /data directory into a new installation?
Date: 2006-11-08 14:59:19
Message-ID: 9E5982E7FA90424D8255B482D11D43930EBBB1@KUDZU.nhb.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, November 07, 2006 4:26 PM
To: David J. Fenske
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Can I substitute a recovered /data directory into a
new installation?

"David J. Fenske" <davidf(at)nhb(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message operationsengineer1 2006-11-09 01:24:17 Re: [SQL] [ADMIN] Is there anyway to...
Previous Message Jonah H. Harris 2006-11-08 14:44:06 Re: synonyms like in oracle?