Re: pg_dump out of shared memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump out of shared memory
Дата
Msg-id 1553.1087825492@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump out of shared memory  (tfo@alumni.brown.edu (Thomas F. O'Connell))
Список pgsql-general
tfo@alumni.brown.edu (Thomas F. O'Connell) writes:
> In using pg_dump to dump an existing postgres database, I get the
> following:

> pg_dump: WARNING:  out of shared memory
> pg_dump: attempt to lock table <table name> failed: ERROR:  out of
> shared memory
> HINT:  You may need to increase max_locks_per_transaction.

> Am I correct in thinking that, despite the
> hint, it's more likely that I need to up the shared_buffers?

No.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Madison Kelly
Дата:
Сообщение: New to the list; would this be an okay question?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PGSQL service dieing...