Re: [ADMIN] Missing chunks from my toast...

2008-06-20 Thread Scott Whitney
Scott Whitney Sent: Jun 20, 2008 12:08 PM To: pgsql-admin@postgresql.org Subject: RE: [ADMIN] Missing chunks from my toast... Tom, Thanks. Here's the output of what just happened: rt3=# select reltoastrelid::regclass from pg_class where relname = '

Re: [ADMIN] Missing chunks from my toast...

2008-06-20 Thread Scott Whitney
OTECTED] Sent: Jun 20, 2008 11:41 AM To: Scott Whitney Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Missing chunks from my toast... "Scott Whitney" <[EMAIL PROTECTED]> writes: > There goes my breakfast... > pg_dump: ERROR: missing chunk number 0 for toast value 110439

Re: [ADMIN] Missing chunks from my toast...

2008-06-20 Thread Tom Lane
"Scott Whitney" <[EMAIL PROTECTED]> writes: > There goes my breakfast... > pg_dump: ERROR: missing chunk number 0 for toast value 110439697 > pg_dump: SQL command to dump the contents of table "attachments" failed: > PQendcopy() failed. > pg_dump: Error message from server: ERROR: missing chunk n

[ADMIN] Missing chunks from my toast...

2008-06-20 Thread Scott Whitney
There goes my breakfast... pg_dump: ERROR: missing chunk number 0 for toast value 110439697 pg_dump: SQL command to dump the contents of table "attachments" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 110439697 pg_dump: The comman