BUG #7761: Out of memory when running pg_dump

From: m(dot)vanklink(at)vision-development(dot)nl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7761: Out of memory when running pg_dump
Date: 2012-12-20 07:04:28
Message-ID: E1TlaBA-0004EK-03@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7761
Logged by: Michel van Klink
Email address: m(dot)vanklink(at)vision-development(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Achyut kumar Dwivedi 2012-12-20 08:09:11 postgers problem in bytea on windows os
Previous Message Tom Lane 2012-12-20 00:36:16 Re: BUG #7758: pg_dump does not correctly dump operators.