Re: [GENERAL] Problem with pg_log file corrupted

2001-04-25 Thread YekFu . Wong
-- Forwarded by YekFu Wong on 04/26/2001 02:27 PM --- YekFu Wong 04/26/2001 07:26 AM To: "Tom Lane" <[EMAIL PROTECTED]> @ INTERNET cc: Subject: Re: [GENERAL] Problem with pg_log file corrupted (Document link: YekFu Wo

Re: [GENERAL] Problem with pg_log file corrupted

2001-04-25 Thread Tom Lane
[EMAIL PROTECTED] writes: > The error message appear when I tried to list all tables is as below : > " cannot flush block 8 of pg_log to stable store " I can't see any good reason why you'd get a failure there ... unless maybe you are out of disk space? Assuming you are running a 7.0.* release,

[GENERAL] Problem with pg_log file corrupted

2001-04-25 Thread YekFu . Wong
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 fi