Re: Need Help Recovering from Botched Upgrade Attempt

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need Help Recovering from Botched Upgrade Attempt
Date: 2008-06-18 15:04:07
Message-ID: 200806180804.07377@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 18 June 2008, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> wrote:
> > Every file from /var/lib/pgsql/ before I started this is on the
> > weekly backup tape from last Friday night. If need be I can restore
> > from that and start over.
>
> Well, no worries then. I'm sure you can understand that for many people
> - way TOO many people - that is not the case, so it's well worth
> stressing the point.

If the database was in use when _that_ backup was taken, it may also not be
usable.

You can't just backup a live database from the filesystem level and expect
it to work ...

--
Alan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-06-18 15:04:16 Re: Correct pg_dumpall Syntax
Previous Message Tom Lane 2008-06-18 14:44:46 Re: Error when trying to drop a tablespace