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

From: Raghu Ram <raghuchennuru(at)gmail(dot)com>
To: christian(dot)echerer(at)manroland-web(dot)com
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Out of shared memory while creating a backup with pg_dump
Date: 2014-09-24 10:33:47
Message-ID: CALnrrJQG2ThCSv7=oR74v6iS6cej0d8=FAZeaGkyc4u8HVDAbg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Sep 24, 2014 at 2:35 PM, <christian(dot)echerer(at)manroland-web(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh dba 2014-09-24 11:14:00 Re: Out of shared memory while creating a backup with pg_dump
Previous Message Shreeyansh dba 2014-09-24 10:02:58 Re: Out of shared memory while creating a backup with pg_dump