From: Marcin Citowicki <marcin.citowicki@m4n.nl>
To: pgsql-performance@postgresql.org
Subject: Re: pg_dump error - out of memory, Failed on request of size 536870912
Date: Wed, 06 Aug 2008 12:26:39 +0200
Message-ID: <48997C5F.6030702@m4n.nl> (raw)
In-Reply-To: <48997383.3040704@m4n.nl>
References: <48997383.3040704@m4n.nl>
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
Attachments:marcin_citowicki.vcf (text/x-vcard, 132B) download
begin:vcard
fn:Marcin Citowicki
n:Citowicki;Marcin
email;internet:marcin.citowicki@m4n.nl
x-mozilla-html:FALSE
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: marcin.citowicki@m4n.nl
Subject: Re: pg_dump error - out of memory, Failed on request of size 536870912
In-Reply-To: <48997C5F.6030702@m4n.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox