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 <[EMAIL PROTECTED]> 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? > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. >
