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.