Message-ID: <48997383.3040704@m4n.nl>
Date: Wed, 06 Aug 2008 11:48:51 +0200
From: Marcin Citowicki <marcin.citowicki@m4n.nl>
User-Agent: Mozilla-Thunderbird 2.0.0.14 (X11/20080509)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: pg_dump error - out of memory, Failed on request of size 536870912
Content-Type: multipart/mixed; boundary="------------090509010407040408070005"

This is a multi-part message in MIME format.
--------------090509010407040408070005
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

We have a bit of a problem with the daily db backup. At the moment the 
backup db size is half of the main db, and we have the following errors 
in the log file:

ERROR: out of memory
DETAIL: Failed on request of size 536870912

(There's a bunch of those.)

There were some 'permission denied for language c' errors earlier in the 
log, but then the backup continued for a while.

This is the command we're running:

pg_dump -c -h $DB_HOST -U $DB_USER $DB_NAME | PGOPTIONS='-c 
maintenance_work_mem=1500MB -c sort_mem=64MB'
psql --quiet -U $DB_DUMP_USER -h $DB_DUMP_HOST $DB_DUMP_NAME;

Both databases (main and backup) are Postgres 8.3.

I'd appreciate any suggestions on how to fix this problem. Also, if you 
have a better idea on running a daily backup please let me know.
Thanks!

Marcin

--------------090509010407040408070005
Content-Type: text/x-vcard; charset=utf-8;
 name="marcin_citowicki.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="marcin_citowicki.vcf"

begin:vcard
fn:Marcin Citowicki
n:Citowicki;Marcin
email;internet:marcin.citowicki@m4n.nl
x-mozilla-html:FALSE
version:2.1
end:vcard


--------------090509010407040408070005--