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