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

Поиск
Список
Период
Сортировка
От Raghu Ram
Тема Re: Out of shared memory while creating a backup with pg_dump
Дата
Msg-id CALnrrJQG2ThCSv7=oR74v6iS6cej0d8=FAZeaGkyc4u8HVDAbg@mail.gmail.com
обсуждение исходный текст
Ответ на Out of shared memory while creating a backup with pg_dump  (<christian.echerer@manroland-web.com>)
Ответы Re: Out of shared memory while creating a backup with pg_dump  (Shreeyansh dba <shreeyansh2014@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Shreeyansh dba
Дата:
Сообщение: Re: Out of shared memory while creating a backup with pg_dump
Следующее
От: Shreeyansh dba
Дата:
Сообщение: Re: Out of shared memory while creating a backup with pg_dump