The following bug has been logged on the website:
Bug reference: 7761
Logged by: Michel van Klink
Email address: m.vanklink@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