Re: trying to restore after a server failure...need some help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David A(dot) Ulevitch" <davidu(at)everydns(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: trying to restore after a server failure...need some help
Date: 2004-04-29 20:36:02
Message-ID: 16542.1083270962@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David A. Ulevitch" <davidu(at)everydns(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2004-04-29 20:40:52 Re: postgresql idle
Previous Message Campano, Troy 2004-04-29 20:35:14 Re: Timestamp problems...wrong weeks.