Re: Out of shared memory while creating a backup with pg_dump

[Shreeyansh dba <shreeyansh2014@xxxxxxxxx>]

On Wed, Sep 24, 2014 at 4:03 PM, Raghu Ram <raghuchennuru@xxxxxxxxx> wrote:

On Wed, Sep 24, 2014 at 2:35 PM, <christian.echerer@xxxxxxxxxxxxxxxxx> 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

www.shreeyansh.com

Thanks & Regards

Raghu Ram