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

From Tom Lane
Subject Re: how to use pg_resetxlog
Date
Msg-id 3871.1066752199@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:
> --installed the 7.2.1 tarball and configured / gmake / install
> --the pg_resetxlog.  when i restarted postmaster, it says 'ok',
> --but when i tried to get in via the command line, i got this:
> [snip]
> psql: FATAL 1:  cannot open pg_attribute: No such file or directory
> [/snip]

> --did i miss a step?

You probably used too small a value for the initial XID setting.  You
need to redo pg_resetxlog with a -x value larger than the number of
transactions elapsed in your database.  You can determine a suitable
number to use by looking in $PGDATA/pg_clog to see the largest file
number there (beware, they are in hex).  Add one, then multiply by 1024*1024.

            regards, tom lane

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: lastval(seq) ?
Next
From: "Johnson, Shaunn"
Date:
Subject: Re: how to use pg_resetxlog