Re: recover corrupt DB?

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(dot)armbrust(dot)list(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>