Re: how to use pg_resetxlog

--you're right about the contrib version - it's wrong.
--can i d/l an old version and recompile it?

-X
-----Original Message-----
From: Tom Lane
To: Johnson, Shaunn
Cc: pgsql-general(at)postgresql(dot)org
Sent: 10/21/03 10:17 AM
Subject: Re: [GENERAL] how to use pg_resetxlog

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> --I did the pg_resetxlog -f $PGDATA and
> --it generated a new log, but when I try to
> --restart the database, it fails. I look in the
> --logs and I see:

> [snip]
> Oct 21 01:32:13 localsvr postgres[2598]: [1] FATAL 2:
> control file context is broken

Are you sure you used the right version of pg_resetxlog? This seems to
indicate that pg_resetxlog produced a bogus pg_control file.
pg_controldata might help to identify the problem.

regards, tom lane