Re: Is my db dead ?

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(at)commandprompt(dot)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?
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>