| 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 ' '" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how to use pg_resetxlog |
| Date: | 2003-10-21 16:03:19 |
| Message-ID: | 3871.1066752199@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:
> --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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnson, Shaunn | 2003-10-21 16:41:37 | Re: how to use pg_resetxlog |
| Previous Message | Oksana Yasynska | 2003-10-21 16:02:34 | Re: plpgsql: return multiple result sets |