Skip site navigation (1) Skip section navigation (2)

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

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: "David A(dot) Ulevitch" <davidu(at)everydns(dot)net>,pgsql-general(at)postgresql(dot)org
Subject: Re: trying to restore after a server failure...need
Date: 2004-04-29 17:35:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I've no suggestions, except that I hope you still have a copy of the 
original /var/lib/postgres/data files and didn't run postgresql on your 
only copy...

At 12:19 PM 4/29/2004 -0500, David A. Ulevitch wrote:

>Hi fellow pgsql users,
>I am helping my university's student union get back up and running after
>some major server issues they had.  They had serious disk issues on a
>server, but not on the /var partition where all of the
>/var/lib/postgres/data files were.  I was able to recover all of it, at
>the file-system level.
>The old machine and the new machine were both running Debian Linux
>3.0-stable and postgresql 7.2.1-2woody4.
>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.

In response to

pgsql-general by date

Next:From: David A. UlevitchDate: 2004-04-29 17:36:23
Subject: Follow-up to original post, more information:
Previous:From: David A. UlevitchDate: 2004-04-29 17:19:14
Subject: trying to restore after a server failure...need some help

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group