pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan I substitute a recovered /data directory into a new installation?
3+ messages / 2 participants
[nested] [flat]
* Can I substitute a recovered /data directory into a new installation?
@ 2006-11-07 23:23 David J. Fenske <davidf@nhb.org>
0 siblings, 1 reply; 3+ messages in thread
From: David J. Fenske @ 2006-11-07 23:23 UTC (permalink / raw)
To: pgsql-admin
Hi -
I have a postgresql 7.4.6 installation that supports a Lyris List
Manager service, running on Red Hat Enterprise ES 4
Last week during a move of the server, the hard drive of the server
suffered some damage in several blocks, that prevented it from booting.
I was able to recover the pgsql directory off of the disk, but have not
been doing regular dumps to recover from.
I have rebuilt the server using a new disk, keeping the same server
name, IP address, etc. I successfully reinstalled postgresql and I'm
trying to substitute the old data directory into the new installation,
however, I get permission problems. 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).
However, I still get problems that the postmaster will not start because
it's getting permission denied on /data/global/pg_control.
I realize that I am not doing this the correct way by restoring a
legitimate backup, but there must be a way to be able to recover the
static files. Can anybody help set me on the right path?
Thanks in advance!
David
David Fenske
Information Technology Administrator
National Honey Board
davidf@nhb.org
(303)776-2337 x 105
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I substitute a recovered /data directory into a new installation?
@ 2006-11-07 23:26 Tom Lane <tgl@sss.pgh.pa.us>
parent: David J. Fenske <davidf@nhb.org>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2006-11-07 23:26 UTC (permalink / raw)
To: David J. Fenske <davidf@nhb.org>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I substitute a recovered /data directory into a new installation?
@ 2006-11-08 14:59 David J. Fenske <davidf@nhb.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: David J. Fenske @ 2006-11-08 14:59 UTC (permalink / raw)
To: pgsql-admin; +Cc: Tom Lane <tgl@sss.pgh.pa.us>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-11-08 14:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-07 23:23 Can I substitute a recovered /data directory into a new installation? David J. Fenske <davidf@nhb.org>
2006-11-07 23:26 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-11-08 14:59 ` David J. Fenske <davidf@nhb.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox