From: Marcin Citowicki <marcin.citowicki@m4n.nl>
To: pgsql-performance@postgresql.org
Subject: pg_dump error - out of memory, Failed on request of size 536870912
Date: Wed, 06 Aug 2008 11:48:51 +0200
Message-ID: <48997383.3040704@m4n.nl> (raw)
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: <48997383.3040704@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