Обсуждение: corrupted pg_proc?

Поиск
Список
Период
Сортировка

corrupted pg_proc?

От
"BRUSSER Michael"
Дата:
<div class="Section1"><p class="MsoNormal">I need to repair the old version of Postgresql.<p class="MsoNormal">pg_dump
doesnot work, I tried few other things but could not come up with any workable scenario.<p class="MsoNormal">Any help
willbe greatly appreciated!<p class="MsoNormal">Thanks,<p class="MsoNormal">Michael.<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">cdb=# vacuum;<p class="MsoNormal">WARNING:  Rel pg_proc: TID 31/20: OID IS
INVALID.TUPGONE 0.<p class="MsoNormal">VACUUM<p class="MsoNormal">cdb=# select version();<p
class="MsoNormal">                              version                                <p
class="MsoNormal">----------------------------------------------------------------------<pclass="MsoNormal"> PostgreSQL
7.3.2on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3<p class="MsoNormal">(1 row)<p class="MsoNormal"> </div> 

Re: corrupted pg_proc?

От
"Pavel Stehule"
Дата:
Hello

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

regards
Pavel Stehule

2008/10/21 BRUSSER Michael <Michael.BRUSSER@3ds.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)
>
>