Postgres Pro
Downloads
Home   >   mailing lists

Re: recover corrupt DB? - Mailing list pgsql-general

From Milos Babic
Subject Re: recover corrupt DB?
Date
Msg-id e0dd88540904231032v254f2d12vcaf268b943b90032@mail.gmail.com
Whole thread Raw
In response to Re: recover corrupt DB?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
List pgsql-general
Tree view

Yes.
Some things like duplicate primary key can exist in pg_resetxlog-ed db.
So, dump db and restore it again on clean initialized cluster.

Regards
Milos

On Thu, Apr 23, 2009 at 8:25 PM, Dan Armbrust <daniel.armbrust.list@gmail.com> wrote:
>   In general, pg_resetxlog would be
> the tool to try here.  Don't panic yet. ;-)
>
>

Yep, that was the command I was looking for.  That at least got the DB
to a point where it would start, and I was able to do a dump.

So, I dumped and reloaded all of the databases.  Things seem fine, but
bits and pieces of documentation I've seen for pg_resetxlog also
recommend initdb, and starting over.  Is that necessary?

Thanks,

Dan

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Dan Armbrust
Date:
Subject: Re: recover corrupt DB?
Next
From: zach cruise
Date:
Subject: utf8 encoding for template0 and template1?