Out of memory on pg_dump

From: "Chris Hopkins" <chopkins(at)cra(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Out of memory on pg_dump
Date: 2009-08-20 18:23:45
Message-ID: 2F740099AD5F8E4BA876BC6580B16D480182856B@server2.cra.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all -

We are using Postgres 8.2.3 as our Confluence backing store and when
trying to backup the database at night we are seeing this in the logs:

<snip>

pg_amop_opc_strat_index: 1024 total in 1 blocks; 216 free (0 chunks);
808 used

pg_aggregate_fnoid_index: 1024 total in 1 blocks; 392 free (0 chunks);
632 used

MdSmgr: 8192 total in 1 blocks; 6376 free (0 chunks); 1816 used

LOCALLOCK hash: 24576 total in 2 blocks; 14112 free (4 chunks); 10464
used

Timezones: 49432 total in 2 blocks; 5968 free (0 chunks); 43464 used

ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used

2009-08-19 22:35:42 ERROR: out of memory

2009-08-19 22:35:42 DETAIL: Failed on request of size 536870912.

2009-08-19 22:35:42 STATEMENT: COPY public.attachmentdata
(attachmentdataid, attversion, data, attachmentid) TO stdout;

Is there an easy way to give pg_dump more memory? I don't see a command
line option for it and I'm not a Postgres expert by any means. This is
the script we are using to backup our DB (backup.cmd):

@ECHO OFF

SET BACKUPS_DIR=C:\backups

SET PGPASSWORD=*******

REM Set the backup file name

SET prefix=confluence_dbbackup_

SET
basename=%prefix%%date:~-4,4%%date:~-10,2%%date:~-7,2%.%time:~-11,2%.%ti
me:~-8,2%.%time:~-5,2%

SET confluence_backup_path=%BACKUPS_DIR%\%basename%.dump

pg_dump --username=confluence --file="%confluence_backup_path%"
--blobs --format c confluence

Thanks,

Chris




THIS MESSAGE IS INTENDED FOR THE USE OF THE PERSON TO WHOM IT IS ADDRESSED. IT MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message and notify the sender so that we may correct our records.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-20 18:31:02 Re: "ownership" of sequences, pseudo random unique id
Previous Message Jeff Davis 2009-08-20 18:11:37 Re: unique index for periods