Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of shared memory while creating a backup with pg_dump - Mailing list pgsql-admin

From Raghu Ram
Subject Re: Out of shared memory while creating a backup with pg_dump
Date
Msg-id CALnrrJQG2ThCSv7=oR74v6iS6cej0d8=FAZeaGkyc4u8HVDAbg@mail.gmail.com
Whole thread Raw
In response to Out of shared memory while creating a backup with pg_dump  (<christian.echerer@manroland-web.com>)
Responses Re: Out of shared memory while creating a backup with pg_dump
List pgsql-admin
Tree view
On Wed, Sep 24, 2014 at 2:35 PM, <christian.echerer@manroland-web.com> wrote:
Hi,

while creating a backup with pg_dump and parallel write accesses to the database following error occured:
2014-09-24 07:46:46 ... ERROR:  out of shared memory
2014-09-24 07:46:46 ... HINT:  You might need to increase max_pred_locks_per_transaction.


This a new parameter introduced in PostgreSQL 9.1. This issue will be resolved by increasing "max_pred_locks_per_transaction" parameter value from default of 64 to 256 in PostgreSQL.conf file.

Thanks & Regards
Raghu Ram 

pgsql-admin by date:

Previous
From: Shreeyansh dba
Date:
Subject: Re: Out of shared memory while creating a backup with pg_dump
Next
From: Shreeyansh dba
Date:
Subject: Re: Out of shared memory while creating a backup with pg_dump