Re: trying to restore after a server failure...need some help - Mailing list pgsql-general

From Tom Lane
Subject Re: trying to restore after a server failure...need some help
Date
Msg-id 16542.1083270962@sss.pgh.pa.us
Whole thread Raw
In response to trying to restore after a server failure...need some help  ("David A. Ulevitch" <davidu@everydns.net>)
List pgsql-general
"David A. Ulevitch" <davidu@everydns.net> writes:
> I did the normal debian binary install of postgresql-server and copies
> everything from the old server's /var/lib/postgres to the new
> /var/lib/postgres.  I then copied everything from /etc/postgresql from the
> old server to the new server too. (/etc was also fine in the crash)  After
> chown'ing all the files to `chown -R postgres.postgres /var/lib/postgres`
> I tried to login.

Uh, was the new machine's postmaster running while you did all this?
You would certainly want the postmaster down while you overwrite
/var/lib/postgres ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Campano, Troy"
Date:
Subject: Re: Timestamp problems...wrong weeks.
Next
From: Andrew Sullivan
Date:
Subject: Re: postgresql idle