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@postgresql.org
Sent: 10/21/03 10:17 AM
Subject: Re: [GENERAL] how to use pg_resetxlog

"Johnson, Shaunn" <SJohnson6@bcbsm.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