The following bug has been logged on the website: Bug reference: 7761 Logged by: Michel van Klink Email address: m.vankl...@vision-development.nl PostgreSQL version: 8.4.3 Operating system: Windows Description:
When running pg_dump it crashes with the following output: pg_dump: dumping contents of table crm_department pg_dump: dumping contents of table crm_department_article pg_dump: dumping contents of table crm_department_extra_info pg_dump: dumping contents of table crm_department_output pg_dump: SQL command failed pg_dump: Error message from server: ERROR: out of memory DETAIL: Failed on request of size 536870912. pg_dump: The command was: COPY public.crm_department_output (crm_department_output_id, document_type, document_format_type, crm_department_id, document_date, origin_type, origin_id, owner_id, og_creation_user, log_creation_dt, log_modification_user, log_modification_dt, document, checkout_dt, checkout_user, checkin_dt, name, document_sequence_integer, amount_excl_vat, amount_incl_vat, lb_currency_id, currency_amount_excl_vat, currency_amount_incl_vat, document_reference, crm_contactperson_id, mailed_dt, faxed_dt, cost_price, printed_dt, start_date, end_date) TO stdout; pg_dump: *** aborted because of error We don't think this is corruption of data because when running the same COPY command from pgAdmin it also crashes with the same error. But when adding WITH BINARY to this command it runs okay. This table contains extremely wide columns, around 130 megabytes. Kind Regards, Michel van Klink Vision Development -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
