Re: Is my db dead ?

Eric Renard escribió:

> pg_dump: Error message from server: ERROR: could not access status of
> transaction 3270404
> DETAIL: could not open file "pg_clog/0003": No such file or directory
> pg_dump: The command was: SELECT tableoid, oid, proname, prolang, pronargs,
> proargtypes, prorettype, proacl, pronamespace, (SELECT rolname FROM
> pg_catalog.pg_roles WHERE oid = proowner) as rolname FROM pg_proc WHERE NOT
> proisagg AND pronamespace != (select oid from pg_namespace where nspname =
> 'pg_catalog')
> pg_dumpall: pg_dump failed on database "postgres", exiting
>
> I read about things like zeroing missing pg_clog files... Can it work ? I
> thought clog files were about transactions, but I don't care about last
> transactions, even data from 1 month ago would be enough for me.
> So what can I do from there ?

Before you start randomly zeroing stuff, do you have any files in
pg_clog? What does that directory look like?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.