Problem with pg_log file corrupted

From: YekFu(dot)Wong(at)seagate(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with pg_log file corrupted
Date: 2001-04-26 03:53:35
Message-ID: OF5E7B3B69.1D98C74F-ON48256A3A.00155D6F@notes.seagate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,
I think the pg_log file of my postgreSQL is corrupted after a power
failure.
I can;t access to tables in my database now.
The error message appear when I tried to list all tables is as below :
" cannot flush block 8 of pg_log to stable store "
Anybody know how can I restore back the pg_log file.
Thanks.

Emmanuel Wong

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-26 05:27:14 Re: Problem with pg_log file corrupted
Previous Message caldodge 2001-04-26 03:42:05 Re: CREATE TABLE AS... syntax?