Re: how to use pg_resetxlog

"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