From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Date: Thu, 11 May 2006 09:53:20 +0400 From: Sisyphus@mail.ru X-Mailer: The Bat! (v3.64.01 Christmas Edition) Professional X-Priority: 3 (Normal) Message-ID: <613234464.20060511095320@mail.ru> To: ALT Linux sysadmin discuss In-Reply-To: <4462C518.2010009@list.ru> References: <1392577196.20060510201901@mail.ru> <4462C518.2010009@list.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: quoted-printable Subject: Re: [Sysadmins] [sisyphus] postgresql (emaphores (SEMMNS), would be exceeded) X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.7 Precedence: list Reply-To: Sisyphus@mail.ru, ALT Linux sysadmin discuss List-Id: ALT Linux sysadmin discuss List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 11 May 2006 05:53:25 -0000 Archived-At: List-Archive: =FA=C4=D2=C1=D7=D3=D4=D7=D5=CA=D4=C5, Genix. =D5=CD=C5=CE=D8=DB=C5=CE=C9=C5 =CB=CF=CC-=D7=CF =CB=CF=CE=C5=CB=D4=CF=D7 = =D2=C5=DB=C1=C5=D4 =D0=D2=CF=C2=CC=C5=CD=D5, =D7=CF=D0=D2=CF=D3 =CB=C1=CB = =D5=D7=C5=CC=C9=DE=C9=D4 =CB=CF=CC=D7=CF =D3=C9=CD=CF=C6=CF=D2=CF=D7 =D7 =D3=C9=DA=C9=C6=C5.. =F0=CF=D0=D2=CF=C2=D9=D7=C1=CC =D3=C4=C5=CC=C1=D4=D8 =C4=C1=CD=D0 =C9 =D7= =CF=D4 =D4=C1=CB=CF=C5: pg_dumpall > outfile pg_dumpall: could not connect to database "template1": could not connect to= server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? =20 =F7=D9 =D0=C9=D3=C1=CC=C9 11 =CD=C1=D1 2006 =C7., 9:01:12: > Sisyphus@mail.ru wrote: >> postgres[14947]: [2-1] FATAL: could not create semaphores: No space le= ft 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. > =D0=CF=D3=CD=CF=D4=D2=C9, =CD=CF=D6=C5=D4 =D2=CF=C4=D3=D4=D7=C5=CE=CE=CF= =C5 =CB =D4=D7=CF=C5=CA =D0=D2=CF=C2=CC=C5=CD=C5 > http://www.opennet.ru/openforum/vsluhforumID1/64940.html#2 >> postgres[14947]: [2-4] ^IIt occurs when either the system limit for the= maximum number of semaphore sets (SEMMNI), or the system wide maximum numb= er of >> postgres[14947]: [2-5] semaphores (SEMMNS), would be exceeded. You ne= ed to raise the respective kernel parameter. Alternatively, reduce Postgre= SQL's >> postgres[14947]: [2-6] consumption of semaphores by reducing its max_c= onnections parameter (currently 512). >> postgres[14947]: [2-7] ^IThe PostgreSQL documentation contains more inf= ormation about configuring your system for PostgreSQL. > =20 > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > =C4=D5=CD=C1=C0 =D3=D4=CF=C9=D4 =DE=C9=D4=C1=D4=D8 =DE=D4=CF =D0=C9=DB=C5= =D4 =D3=C9=D3=D4=C5=CD=C1 ;) >> postgres[14947]: [3-1] LOG: shmctl(25755662, 0, 0) failed: Invalid arg= ument >> postgresql: failed --=20 =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD, Sisyphus mailto:Sisyphus@mail.ru