From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Date: Wed, 10 May 2006 20:19:01 +0400 From: Sisyphus@mail.ru X-Mailer: The Bat! (v3.64.01 Christmas Edition) Professional X-Priority: 3 (Normal) Message-ID: <1392577196.20060510201901@mail.ru> To: sysadmins@lists.altlinux.org Resent-From: Sisyphus@mail.ru MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1251 Content-Transfer-Encoding: quoted-printable Resent-Message-Id: Resent-Date: Wed, 10 May 2006 20:18:54 +0400 Subject: [Sysadmins] [sisyphus] postgresql (emaphores (SEMMNS), would be exceeded) X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.7 Precedence: list Reply-To: ALT Linux sysadmin discuss List-Id: ALT Linux sysadmin discuss List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 10 May 2006 16:18:54 -0000 Archived-At: List-Archive: =0D=0Arpm -qa | grep postgresql postgresql-7.4.9-alt1.1 postgresql-server-7.4.9-alt1.1 # tcpip_socket =3D true max_connections =3D 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 =3D 2 #port =3D 5432 # unix_socket_directory =3D '/var/sockets' #unix_socket_group =3D 'sockets' #unix_socket_permissions =3D 0777 # octal #virtual_host =3D '' # what interface to listen on; defaults to any #rendezvous_name =3D '' # 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 ma= ximum 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_conn= ections parameter (currently 512). postgres[14947]: [2-7] ^IThe PostgreSQL documentation contains more inform= ation about configuring your system for PostgreSQL. postgres[14947]: [3-1] LOG: shmctl(25755662, 0, 0) failed: Invalid argume= nt postgresql: failed =CA=E0=EA =F1 =FD=F2=E8=EC =E1=EE=F0=EE=F2=FC=F1=FF ? max_connections =3D 100 =E5=F1=EB=E8 =F3=EC=E5=ED=FC=F8=E8=F2=FC =E4=EE 100= =EA=EE=ED=E5=EA=F2=EE=E2 =F2=EE postgresql =F1=F2=E0=F0=F2=F3=E5=F2 =ED=EE =E2=EE=F2 =FD=F2=EE =EE=F1=F2=E0=E5=F2=F1= =FF : LOG: could not create IPv6 socket: Address family not supported by protocol =C8 =EA=E0=EA =E2=F1=E5=F2=E0=EA=E8 =F0=E5=F8=E8=F2=FC =EF=F0=EE=E1=EB=E5= =EC=F3 =F6=E5=EB=E8=EA=EE=EC ? --=20 =D1 =F3=E2=E0=E6=E5=ED=E8=E5=EC, Sisyphus mailto:Sisyphus@mail.ru _______________________________________________ Sisyphus mailing list Sisyphus@lists.altlinux.org https://lists.altlinux.org/mailman/listinfo/sisyphus