Failed system call was shmget(key=1, size=1155072, 03600).

Поиск
Список
Период
Сортировка
От Andrew M
Тема Failed system call was shmget(key=1, size=1155072, 03600).
Дата
Msg-id D5FFC45E-4509-11D9-8632-0003938366A4@jibeya.com
обсуждение исходный текст
Ответы Re: Failed system call was shmget(key=1, size=1155072, 03600).
Re: Failed system call was shmget(key=1, size=1155072, 03600).
Список pgsql-sql
Hi,
when building postgreSQL 8 I get the following error message:

DETAIL:  Failed system call was shmget(key=1, size=1155072, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared 
memory segment exceeded available memory or swap space. To reduce the 
request size (currently 1155072 bytes), reduce PostgreSQL's 
shared_buffers parameter (currently 50) and/or its max_connections 
parameter (currently 10)

What is the best way to resolve this? max_connections = 10? Does that 
figure auto increase as more users request data?

regards

Andrew



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

Предыдущее
От: Andrew - Supernews
Дата:
Сообщение: Re: find the "missing" rows
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: Failed system call was shmget(key=1, size=1155072, 03600).