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.l...@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 >
