[Sysadmins] [sisyphus] postgresql (emaphores (SEMMNS), would be exceeded)

* [Sysadmins] [sisyphus]  postgresql (emaphores (SEMMNS), would be exceeded)
@ 2006-05-10 16:19 Sisyphus
  2006-05-11  5:01 ` Genix
  0 siblings, 1 reply; 8+ messages in thread
From: Sisyphus @ 2006-05-10 16:19 UTC (permalink / raw)
  To: sysadmins

\r
rpm -qa | grep postgresql
postgresql-7.4.9-alt1.1
postgresql-server-7.4.9-alt1.1

#
tcpip_socket = true
max_connections = 100
    # note: increasing max_connections costs about 500 bytes of shared
    # memory per connection slot, in addition to costs from shared_buffers
        # and max_locks_per_transaction.
#superuser_reserved_connections = 2
#port = 5432
#
unix_socket_directory = '/var/sockets'
#unix_socket_group = 'sockets'
#unix_socket_permissions = 0777 # octal
#virtual_host = ''       # what interface to listen on; defaults to any
#rendezvous_name = ''       # defaults to the computer name

 postgres[14947]: [1-1] LOG:  could not create IPv6 socket: Address family not supported by protocol
 postgres[14947]: [2-1] FATAL:  could not create semaphores: No space left on device
 postgres[14947]: [2-2] DETAIL:  Failed system call was semget(5432018, 17, 03600).
 postgres[14947]: [2-3] HINT:  This error does *not* mean that you have run out of disk space.
 postgres[14947]: [2-4] ^IIt occurs when either the system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of
 postgres[14947]: [2-5]  semaphores (SEMMNS), would be exceeded.  You need to raise the respective kernel parameter.  Alternatively, reduce PostgreSQL's
 postgres[14947]: [2-6]  consumption of semaphores by reducing its max_connections parameter (currently 512).
 postgres[14947]: [2-7] ^IThe PostgreSQL documentation contains more information about configuring your system for PostgreSQL.
 postgres[14947]: [3-1] LOG:  shmctl(25755662, 0, 0) failed: Invalid argument
 postgresql:  failed

 Как с этим бороться ?

max_connections = 100 если уменьшить до 100 конектов то postgresql
стартует но вот это остается :
LOG:  could not create IPv6 socket: Address family not supported by protocol

И как всетаки решить проблему целиком ?

-- 
С уважением,
 Sisyphus                          mailto:Sisyphus@mail.ru

_______________________________________________
Sisyphus mailing list
Sisyphus@lists.altlinux.org
https://lists.altlinux.org/mailman/listinfo/sisyphus

^ permalink raw reply	[flat|nested] 8+ messages in thread