Thread: recovery from a bad transaction log

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 ???

pg

On Wed, Jul 30, 2003 at 10:36:03AM -0400, pgboy@guthrie.charm.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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

that's what i was looking for. thanks. and i see what you mean
about not really trusting that the data really is all there.
still, most is better than none.

again, thnks.
pg