toast values

Started by Eric Anderson Vianet SAOover 22 years ago1 messagesgeneral
Jump to latest
#1Eric Anderson Vianet SAO
eric@vianet-express.com.br

when I try to do a dump

pg_dump -v -f dump.dmp dtbtransporte

i get following error:

DEBUG: database system was shut down at 2003-08-08 09:40:10 BRT

DEBUG: checkpoint record is at 6/7E2E3D9C

DEBUG: redo record is at 6/7E2E3D9C; undo record is at 0/0; shutdown TRUE

DEBUG: next transaction id: 4153723; next oid: 7794648

DEBUG: database system is ready

ERROR: unexpected chunk number 8 (expected 0) for toast value 6935693

DEBUG: pq_flush: send() failed: Broken pipe

how could I fix it

I already reindexed system table (I´ve started postgres standalone and did REINDEX DATABASE dtbtransporte FORCE).

tnx

Eric