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)
Список
Дерево обсуждения
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 Kevin Grittner <kgrittn@ymail.com>
Re: Out of shared memory while creating a backup with pg_dump Shreeyansh dba <shreeyansh2014@gmail.com>
Re: Out of shared memory while creating a backup with pg_dump Raghu Ram <raghuchennuru@gmail.com>
Re: Out of shared memory while creating a backup with pg_dump Shreeyansh dba <shreeyansh2014@gmail.com>


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
Дата:
Следующее
От: Raj Gandhi
Дата:
FAQ