From: | Sam Saffron <sam(dot)saffron(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Failure upgrading PG 9.2 to 9.3 |
Date: | 2014-03-25 23:32:17 |
Message-ID: | CAAtdryOhp4nWnNBUG4Y5zi2N299H-bUBoQ8yf0EWKkeak=m+ug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks heaps Tom,
I can confirm corrupt db upgrades fine with pg_dump. Was wondering if
there are any plans to add a --no-validate to pg_upgrade, since the
crash seems only to happen during validation.
Cheers
Sam
On Wed, Mar 26, 2014 at 3:19 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Sam Saffron <sam(dot)saffron(at)gmail(dot)com> writes:
>> Why would
>> "ERROR: operator does not exist: name !~ unknown"
>> Come up ?
>
> It's hard to explain that as anything except corrupted system catalogs
> in your existing database :-(. If you were really lucky, reindexing
> pg_operator would fix it; but since pg_operator is usually pretty static,
> it seems unlikely that it suffered index corruption.
>
>> Any way to work around this?
>
> Rather than relying on pg_upgrade, you could try using pg_dump(all)
> to extract the data. With some luck, pg_dump wouldn't be affected by
> whatever has happened to the pg_operator catalog.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-03-25 23:39:06 | Re: Failure upgrading PG 9.2 to 9.3 |
Previous Message | Steven Schlansker | 2014-03-25 23:17:40 | Re: Trimming transaction logs after extended WAL archive failures |