I have only 2 files in this dir :
total 336
-rw------- 1 postgres postgres 262144 2006-11-15 18:34 0000
-rw------- 1 postgres postgres 73728 2008-02-05 14:09 0001
I thought clog files were only files related to transactions in progress ? There's no way to tell psql to ignore all current transactions and act like if they were rolled back or something ?
On Feb 5, 2008 8:47 PM, Alvaro Herrera <
alvherre@commandprompt.com> wrote:
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?
--
The PostgreSQL Company - Command Prompt, Inc.
