On Wed, Jul 30, 2003 at 10:36:03AM -0400, [EMAIL PROTECTED] 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
<[EMAIL PROTECTED]> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
