From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | postgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need Help Recovering from Botched Upgrade Attempt |
Date: | 2008-06-18 13:34:31 |
Message-ID: | Pine.LNX.4.64.0806180629120.10791@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 18 Jun 2008, Craig Ringer wrote:
> I hope you mean cp -aR , because you need those subdirectories if you're
> ever going to try to use the _old copy. Even if you actually did a
> recursive copy, if you really copied the data directories with the DB
> server running and without executing:
Craig,
According to the cp man page here, 'cp -a' is equivalent to 'cp -dpR'.
> select pg_start_backup('migrate');
>
> or similar before starting the copy then you're going to have problems
> using that data. You can copy a working postgresql instance's data
> directories, but only if you've enabled WAL logging and you tell Pg about
> it so it can write appropriate markers for recovery.
This is interesting. I've not read about this before. As I'm the only one
using the databases (primarily for the accounting data) I know that nothing
was changed during the copy operation.
> Right now, you probably need to make REALLY sure you've put a copy of
> those dumps somewhere safe, because I suspect your _old copy will be
> useless. Then use 8.3's initdb on a new, empty directory, verify that the
> config files are correct, and start the 8.3 server.
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.
Thanks,
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2008-06-18 13:42:08 | Re: Need Help Recovering from Botched Upgrade Attempt |
Previous Message | Jonathan Bond-Caron | 2008-06-18 13:24:55 | Re: Database design: Storing app defaults |