Message-ID: <48997C5F.6030702@m4n.nl>
Date: Wed, 06 Aug 2008 12:26:39 +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: Re: pg_dump error - out of memory,
 Failed on request of size 536870912
References: <48997383.3040704@m4n.nl>
In-Reply-To: <48997383.3040704@m4n.nl>
Content-Type: multipart/mixed; boundary="------------050505000601020105050006"

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

Hello,

I forgot to add - all those 'out of memory' errors happen when backup db 
is trying to create index. Every 'CREATE INDEX' operation is followed by 
'out of memory' error.
Thanks!

Marcin


Marcin Citowicki wrote:
> 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

--------------050505000601020105050006
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


--------------050505000601020105050006--