Re: Unable to dump database using pg_dump

From: Adam Dear <adear(at)usnx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to dump database using pg_dump
Date: 2008-06-11 23:05:05
Message-ID: 48505A21.8080301@usnx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)usnx(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-06-11 23:32:29 Re: Unable to dump database using pg_dump
Previous Message Tom Lane 2008-06-11 23:02:36 Re: Missing chunk number on a view?