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.