Re: how to use pg_resetxlog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to use pg_resetxlog
Date: 2003-10-21 14:17:54
Message-ID: 21946.1066745874@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2003-10-21 15:02:51 Re: how to use pg_resetxlog
Previous Message James Moe 2003-10-21 14:16:45 Re: Recomended FS