Re: Unable to dump database using pg_dump

[Adam Dear <adear@xxxxxxxx>]

I tried:

Vacuum Freeze pg_shadow;

Then

Reindex database madisoncounty;

Then

Delete from pg_shadow where ctid='(0,1)';


The record is still there.

Tom Lane wrote:
> Adam Dear <adear@xxxxxxxx> writes:
> > I tried:
> > Delete from pg_shadow where ctid = '(0,1)';
> > DELETE 0
>
> This is looking more and more like a transaction ID wraparound problem.
> Did you try the vacuum freeze suggestion?
>
> 			regards, tom lane