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

[Raghu Ram <raghuchennuru@xxxxxxxxx>]

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.

Thanks & Regards

Raghu Ram