Re: recovery from xid wraparound - Mailing list pgsql-general

From Shane Wright
Subject Re: recovery from xid wraparound
Date
Msg-id 64F50E3BAAE32A4FA0686CF651E0D476146BCC@exchange11.ad.edigitalresearch.com
Whole thread Raw
In response to recovery from xid wraparound  ("Shane Wright" <shane.wright@edigitalresearch.com>)
List pgsql-general
Tom,

Thanks

But are there just 28 (the 28 that have been vacuumed), or are there more (in 7.4).

Happy there's no guarantee, but would help to know any possible damager in my current situation,

Thanks

S



-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 24 October 2006 15:23
To: Shane Wright
Cc: Martijn van Oosterhout; pgsql-general@postgresql.org
Subject: Re: [GENERAL] recovery from xid wraparound


"Shane Wright" <shane.wright@edigitalresearch.com> writes:
>> Just make sure you've really covered *all* the system tables.

> I've been under the impression system tables get done first, then
> user(me)-created tables after -

No, there's no such guarantee.  A database-wide vacuum just does the tables in the order it finds 'em in pg_class.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: recovery from xid wraparound
Next
From: "Wes Sheldahl"
Date:
Subject: Re: unstable postgres on freebsd