Postgres Pro
Downloads
Home   >   mailing lists

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

From Shreeyansh dba
Subject Re: Out of shared memory while creating a backup with pg_dump
Date
Msg-id CAGDYbUPJA4W43mEHjNb9-jpToZJm_-N_99B__qrj1RzFqNcebg@mail.gmail.com
Whole thread Raw
In response to Re: Out of shared memory while creating a backup with pg_dump  (Raghu Ram <raghuchennuru@gmail.com>)
List pgsql-admin
Tree view


On Wed, Sep 24, 2014 at 4:03 PM, Raghu Ram <raghuchennuru@gmail.com> wrote:
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.



Along with this above parameters also change from max_wal_sender=1 to max_wal_sender=5

Hope this will resolve your issue.

Thanks & Regards ,
Chetan Sharma

Thanks & Regards
Raghu Ram 


pgsql-admin by date:

Previous
From: Raghu Ram
Date:
Subject: Re: Out of shared memory while creating a backup with pg_dump
Next
From: Raj Gandhi
Date:
Subject: Re: format() function with string_agg