From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | "Michael L(dot) Boscia" <mikeboscia(at)gmail(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dump after transaction id wraparound failure |
Date: | 2006-05-15 18:53:45 |
Message-ID: | 1147719225.9755.133.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 2006-05-15 at 13:48, Martijn van Oosterhout wrote:
> On Mon, May 15, 2006 at 11:44:01AM -0700, Michael L. Boscia wrote:
> > Hello-
> >
> > I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing
> > transaction id wraparound. I plan to pg_dump the database and initdb and
> > reload. I may reload into an 8.1 database at this time.
> >
> > I am curious how to make sure that I indeed get all the data out of the
> > tables from a pg_dump. I want to ensure that there would not be anything
> > "hidden" by the transaction id wraparound failure.
>
> pg_dump obviously won't see anything that's hidden by wraparound
> failure.
>
> Vacuum will make anything that disappeared by wraparound in the last
> billion transactions reappear, so a databasewide vacuum should solve
> all your problems, no need to dump...
>
> > My current plan is selectively dump a portion of the data (most current,
> > organized in tables by date ex xxx_2006_may) and reload. I plan to vaccuum
> > each table before dumping. Please warn me if this is not enough. Any
> > assistance is greatly appreciated.
>
> I'd say do the vacuum first, dumping the data isn't really helping much
> in this case I think (although for backups it's obviously important).
This is one of those rare instances when I'd shut down the server and
take a file system backup if I could. However, at 1.4 TB, that might be
a bit difficult... :)
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-05-15 19:01:55 | Re: pg_dump after transaction id wraparound failure |
Previous Message | Dave Page | 2006-05-15 18:49:28 | Re: GUI Interface |