From: | Alain Peyrat <aljeux(at)free(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | vacuumdb: PANIC: corrupted item pointer |
Date: | 2007-07-10 12:10:24 |
Message-ID: | 20070710141024.ks20ex86go8ooos8@imp4.free.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
System: Red Hat Linux 4 64bits running postgres-7.4.16 (production)
Initial problem:
# pg_dump -O dbname -Ft -f /tmp/database.tar
pg_dump: query to get table columns failed: ERROR: invalid memory
alloc request size 9000688640
After some research, it seems to be related to a corruption of the
database. Running a vacum crashes the db:
-bash-3.00$ vacuumdb -z -a
vacuumdb: vacuuming database "template1"
vacuumdb: vacuuming of database "template1" failed: PANIC: corrupted
item pointer: offset = 3336, size = 20
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
-bash-3.00$
Can someone help me to track down the problem ?
Can I recover the datas (last backup failed) ?
Best regards,
Alain.
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2007-07-10 12:14:30 | Re: russian case-insensitive regexp search not working |
Previous Message | John DeSoi | 2007-07-10 11:35:59 | Re: catalog location |