FATAL error after a system crash - Mailing list pgsql-general

From Feng-Cheng Chang
Subject FATAL error after a system crash
Date
Msg-id 3CD380B5.9020708@alumni.nctu.edu.tw
Whole thread Raw
Responses Re: FATAL error after a system crash
List pgsql-general
Hello everybody,

My system crashed two days ago. After the system restarted, the
postmaseter also started without any error messages. The problem happens
when I try to
connect to the database using either psql or JDBC, it says

"FATAL 1: cannot open pg_variable: no such file or directory"

and terminates the connection.

Is there any chance to recover the database to a "workable" state?
Because I forgot to backup for a few weeks, the latest dump is
quite out-of-date :(
Frankly speaking, I have no idea about where the problem is.
Hope this is not really a "fatal" crash.

Would any kind people here help me to recover the DB?
If the data are corrupted and the database should be re-initialized,
is there any method to retrieve as much data as possible from the old
repository files?

P.S.
My system configuration:
Win2k server
cygwin + postgresql 7.1.3


Thank you very much!!

Feng-Chang Chang



pgsql-general by date:

Previous
From: "Bertin, Philippe"
Date:
Subject: IF- statements in a rule's 'DO INSTEAD SELECT ...'- statement
Next
From: Alan Wayne
Date:
Subject: Re: HOWTO - Random character generation for primary key