Re: Unable to dump database using pg_dump - Mailing list pgsql-general

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@usnx.net> 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
>