Re: running two servers on one machine

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: running two servers on one machine
Дата
Msg-id 28429.1238465886@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: running two servers on one machine  (Eric Smith <eric_h_smith@mac.com>)
Ответы Re: running two servers on one machine  (Eric Smith <eric_h_smith@mac.com>)
Список pgsql-general
Eric Smith <eric_h_smith@mac.com> writes:
> Log file says "could not create shared memory segment".  It also says
> that I should change max_connections or shared_buffers.

> Error message claims that max_connections is 23, but postgresql.conf
> has this listed as 20.

The autovacuum workers get added on.

> Error message claims that shared_buffers is 300, but postgresql.conf
> has this listed as 2400kB.

Same thing, different units.

Anyway, you left out the interesting part of the error message,
ie the kernel error code.  If it's "Cannot allocate memory" then
you probably need to increase SHMALL.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgstattuple triggered checkpoint failure and database outage?
Следующее
От: Eric Smith
Дата:
Сообщение: Re: running two servers on one machine