From: | "Michael L(dot) Boscia" <mikeboscia(at)gmail(dot)com> |
---|---|
To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Michael L(dot) Boscia" <mikeboscia(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump after transaction id wraparound failure |
Date: | 2006-05-15 23:14:23 |
Message-ID: | 45caccdc0605151614m53022a0bsdb60cd19bc2ce661@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> And I just demonstrated it on a test 7.4.7 database here (Debian
> 7.4.7-6 to be precise).
>
> test=# select ctid, xmin, xmax, cmin, cmax, * from test;
> ctid | xmin | xmax | cmin | cmax | x
> -------+------------+------+------+------+---
> (0,1) | 541 | 0 | 0 | 0 | 1
> (0,2) | 2147484153 | 0 | 0 | 0 | 2
> (0,3) | 2147484183 | 0 | 0 | 0 | 3
> (3 rows)
>
> ### Row is still there...
>
> test=# select ctid, xmin, xmax, cmin, cmax, * from test;
> ctid | xmin | xmax | cmin | cmax | x
> -------+------------+------+------+------+---
> (0,2) | 2147484153 | 0 | 0 | 0 | 2
> (0,3) | 2147484183 | 0 | 0 | 0 | 3
> (2 rows)
>
> ### OMG, row is gone
>
> test=# vacuum test;
> VACUUM
> test=# select ctid, xmin, xmax, cmin, cmax, * from test;
> ctid | xmin | xmax | cmin | cmax | x
> -------+------------+------+------+------+---
> (0,1) | 2 | 0 | 0 | 0 | 1
> (0,2) | 2147484153 | 0 | 0 | 0 | 2
> (0,3) | 2147484183 | 0 | 0 | 0 | 3
> (3 rows)
>
> ### Yay row is back
> test=# select version();
> version
> -------------------------------------------------------------------------------------------------------
> PostgreSQL 7.4.7 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.5 (Debian 1:3.3.5-12)
> (1 row)
>
> Have a ncie day,
> --
To Clarify - So the consensus is to vacuum the entire database? This
should take care of any possible loss of data. Then after this I
should pg_dump?
Thanks again
--Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2006-05-15 23:39:38 | Re: parameter passing from java program |
Previous Message | salah jubeh | 2006-05-15 22:30:00 | crashed winxp |