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

From Tom Lane
Subject Re: how to use pg_resetxlog
Date
Msg-id 21946.1066745874@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to use pg_resetxlog  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
"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: "James Moe"
Date:
Subject: Re: Recomended FS
Next
From: "Johnson, Shaunn"
Date:
Subject: Re: how to use pg_resetxlog