| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: recovery from a bad transaction log |
| Date: | 2003-07-30 17:18:08 |
| Message-ID: | 20030730171807.GD12794@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Jul 30, 2003 at 10:36:03AM -0400, pgboy(at)guthrie(dot)charm(dot)net wrote:
>
> given that someone (else) deleted the pg_xlog directory, or that it got
> otherwise corrupted, is there a way to regenerate the database, given
> that all the data is still safely tucked away in $PGDATA/base ???
Well, I'm not too sure how correct that is (how do you know _all_ the
data is there), but you could try pg_resetxlog. I'd go looking for
data in an inconsistent state afterwards, though.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-30 17:23:11 | Re: syslog enabled causes random hangs? |
| Previous Message | tech techie | 2003-07-30 17:16:30 | LargeObjectDrop and simple_heap_delete - Are these errors normal? |