ALT Linux sysadmins discussion
 help / color / mirror / Atom feed
* [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

end of thread, other threads:[~2006-05-11  8:28 UTC | newest]

Thread overview: 8+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2006-05-10 16:19 [Sysadmins] [sisyphus] postgresql (emaphores (SEMMNS), would be exceeded) Sisyphus
2006-05-11  5:01 ` Genix
2006-05-11  5:53   ` Sisyphus
2006-05-11  6:45     ` Genix
2006-05-11  8:03       ` Sisyphus
2006-05-11  8:07         ` Genix
2006-05-11  8:16           ` Sisyphus
2006-05-11  8:28             ` Genix

ALT Linux sysadmins discussion

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/sysadmins/0 sysadmins/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 sysadmins sysadmins/ http://lore.altlinux.org/sysadmins \
		sysadmins@lists.altlinux.org sysadmins@lists.altlinux.ru sysadmins@lists.altlinux.com
	public-inbox-index sysadmins

Example config snippet for mirrors.
Newsgroup available over NNTP:
	nntp://lore.altlinux.org/org.altlinux.lists.sysadmins


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git