Re: corrupted pg_proc?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "BRUSSER Michael" <Michael(dot)BRUSSER(at)3ds(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: corrupted pg_proc?
Date: 2008-10-21 14:10:16
Message-ID: 162867790810210710w1377e14bp9c8c57da01ab9f07@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

try to http://svana.org/kleptog/pgsql/pgfsck.html

regards
Pavel Stehule

2008/10/21 BRUSSER Michael <Michael(dot)BRUSSER(at)3ds(dot)com>:
> I need to repair the old version of Postgresql.
>
> pg_dump does not work, I tried few other things but could not come up with
> any workable scenario.
>
> Any help will be greatly appreciated!
>
> Thanks,
>
> Michael.
>
>
>
>
>
> cdb=# vacuum;
>
> WARNING: Rel pg_proc: TID 31/20: OID IS INVALID. TUPGONE 0.
>
> VACUUM
>
> cdb=# select version();
>
> version
>
> ----------------------------------------------------------------------
>
> PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3
>
> (1 row)
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-10-21 14:11:41 Re: minimal update
Previous Message Simon Riggs 2008-10-21 14:06:20 Hot Standby: Caches and Locks