Hi, I just ran into an error from pg_dump:
/usr/local/pgsql/bin/pg_dump -F p my_db pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value 144391872 pg_dump: SQL command to dump the contents of table "measured_bioassay_base" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: unexpected chunk number 3292 (expected 5) for toast value 144391872 pg_dump: The command was: COPY public.measured_bioassay_base (bioassay_id, name, owner_id, writer_id, readers_id, is_deleted, delete_time, expt_id, protocol_application_id, source_bioassay_id, filename, fileheader, format, date_uploaded) TO stdout; Any ideas whats happened here? It looks like one of my tables hasn't backed up correctly. This table has a text field which contains large amounts of data per field. The dump file is much smaller than last nights dump. (PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC 2.95.4) Thanks for any help Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
