Merhaba
Bildigim kadari ile sunlar yeterli
options SHMMAXPGS=65536
options SEMMNI=256
options SEMMNS=512
options SEMUME=64
options SEMMNU=128
----- Original Message -----
From: "Ali Çelik" <[EMAIL PROTECTED]>
To: <freebsd@lists.enderunix.org>
Sent: Monday, November 06, 2006 2:25 PM
Subject: [FreeBSD] PostgreSQL max connection
Merhaba
FreeBSD de Postgresql 8.0.X için max_connection öntanımlı değeri 40
geliyor ve yükseltmek istedğimizde Servisi başlatamıyoruz. bağlantı
sayısını 100 yapabilmek için Kernel parametrelerinde nasıl bir
değişiklik yapmam gerekiyor.
Nov 4 22:32:14 mail postgres[68705]: [1-1] FATAL: could not create
semaphores: No space left on device
Nov 4 22:32:14 mail postgres[68705]: [1-2] DETAIL: Failed system
call was semget(5432004, 17, 03600).
Nov 4 22:32:14 mail postgres[68705]: [1-3] HINT: This error does
*not* mean that you have run out of disk space.
Nov 4 22:32:14 mail postgres[68705]: [1-4] It occurs when either the
system limit for the maximum number of semaphore sets (SEMMNI),
or the system wide maximum number of
Nov 4 22:32:14 mail postgres[68705]: [1-5] semaphores (SEMMNS),
would be exceeded.
You need to raise the respective kernel parameter. Alternatively,
reduce PostgreSQL's
Nov 4 22:32:14 mail postgres[68705]: [1-6] consumption of semaphores
by reducing its max_connections parameter (currently 100).
Nov 4 22:32:14 mail postgres[68705]: [1-7] The PostgreSQL
documentation contains more information about configuring your system
for PostgreSQL.
---------------------------------------------------------------------
Cikmak icin, e-mail: [EMAIL PROTECTED]
Liste arsivi: http://lists.enderunix.org
Turkiye'nin ilk FreeBSD kitabi: http://www.acikakademi.com/freebsd.php
