Re: [GENERAL] VACUUM PANIC: corrupted item pointer

2008-10-17 Thread André Volpato
Tom Lane escreveu: =?ISO-8859-1?Q?Andr=E9_Volpato?= <[EMAIL PROTECTED]> writes: 8. Postgres is up, but... # psql matriz psql: FATAL: could not read block 0 of relation 1664/0/2676: read only 0 of 8192 bytes Looks like your raid array is dying under you :-( ... We hope it last more 3

Re: [GENERAL] VACUUM PANIC: corrupted item pointer

2008-10-17 Thread Tom Lane
=?ISO-8859-1?Q?Andr=E9_Volpato?= <[EMAIL PROTECTED]> writes: > 8. Postgres is up, but... > # psql matriz > psql: FATAL: could not read block 0 of relation 1664/0/2676: read only > 0 of 8192 bytes Looks like your raid array is dying under you :-( ... 2676 is pg_authid_rolname_index, so you could

Re: [GENERAL] VACUUM PANIC: corrupted item pointer

2008-10-17 Thread André Volpato
André Volpato escreveu: 10. Same error # psql matriz psql: FATAL: could not read block 0 of relation 1664/0/2676: read only 0 of 8192 bytes Right now this is the message I got every time I try to connect, even in single mode. We tried to fsck the raid partition, but with no luck. Hope ther

[GENERAL] VACUUM PANIC: corrupted item pointer

2008-10-17 Thread André Volpato
Hi, We got a corrupted database server, and I need some advice on what else can I do. Specs: - Postgres 8.3.3 @ Linux dbserver4 2.6.24-etchnhalf.1-686-bigmem - 4 GB RAM - PGDATA with 700GB (70GB used), software RAID-0 with 3 sata-2 (blame it on me, ugh...) So, the steps till now: 1 - Vacuum