Re: how to use pg_resetxlog - Mailing list pgsql-general

From Johnson, Shaunn
Subject Re: how to use pg_resetxlog
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FEDAD7@snt452.corp.bcbsm.com
Whole thread Raw
In response to how to use pg_resetxlog  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Responses Re: how to use pg_resetxlog
List pgsql-general

 
--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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to use pg_resetxlog
Next
From: Tom Lane
Date:
Subject: Re: how to use pg_resetxlog