corrupted pg_proc?
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)
Hello
try to http://svana.org/kleptog/pgsql/pgfsck.html
regards
Pavel Stehule
2008/10/21 BRUSSER Michael <Michael.BRUSSER@3ds.com>:
Show quoted text
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)