From: | "Lukasz Piskorz" <lpiskorz(at)ists(dot)pwr(dot)wroc(dot)pl> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Help - postgresql 7.0 and cannot read block 7959 of pg_log |
Date: | 2004-02-19 13:13:42 |
Message-ID: | 003701c3f6ea$33909780$0400a8c0@vivid.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I need very fast help.
When I worked in postgresql 7.0 I saw message:
database=>NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.
The connection to the server was lost. Attempting reset: Succeeded.
When I check all tables only one (very important in my database) is
corrupted:
database=>select * from table;
ERROR: cannot read block 7959 of pg_log: Success
Could you help me? What can I do? Can I remove this table and restore from
backup? What do you think about software
http://svana.org/kleptog/pgsql/pgfsck.html ?
Best,
Lukas
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-19 14:30:14 | Re: ANALYZE crashes randomly |
Previous Message | Guy Smith | 2004-02-19 10:52:16 | Concerned about previous version still in place |