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
Дата
Msg-id CAGDYbUPJA4W43mEHjNb9-jpToZJm_-N_99B__qrj1RzFqNcebg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Out of shared memory while creating a backup with pg_dump  (Raghu Ram <raghuchennuru@gmail.com>)
Список pgsql-admin
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Raghu Ram
Дата:
Сообщение: Re: Out of shared memory while creating a backup with pg_dump
Следующее
От: Raj Gandhi
Дата:
Сообщение: Re: format() function with string_agg