X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 89A4D9FA38E for ; Wed, 10 May 2006 16:45:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 66742-01 for ; Wed, 10 May 2006 16:45:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 22FDB9FA293 for ; Wed, 10 May 2006 16:45:50 -0300 (ADT) Received: from mx2.mail.ru (mx2.mail.ru [194.67.23.122]) by svr4.postgresql.org (Postfix) with ESMTP id 2A1925B3A0A for ; Wed, 10 May 2006 19:45:49 +0000 (GMT) Received: from [194.85.159.154] (port=60662 helo=WIN) by mx2.mail.ru with asmtp id 1Fducy-000DHn-00 for pgsql-admin@postgresql.org; Wed, 10 May 2006 23:45:44 +0400 Date: Wed, 10 May 2006 23:45:52 +0400 From: Sisyphus@mail.ru X-Mailer: The Bat! (v3.64.01 Christmas Edition) Professional Reply-To: Sisyphus@mail.ru X-Priority: 3 (Normal) Message-ID: <1735235158.20060510234552@mail.ru> To: pgsql-admin@postgresql.org Subject: posgresql AltLinux MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1251 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/119 X-Sequence-Number: 21651 rpm -qa | grep postgresql postgresql-7.4.9-alt1.1=20 postgresql-server-7.4.9-alt1.1=20 #=20 tcpip_socket =3D true=20 max_connections =3D 512# note: increasing max_connections costs about 500 b= ytes of shared=20 # memory per connection slot, in addition to costs from shared_buffers=20 # and max_locks_per_transaction.=20 #superuser_reserved_connections =3D 2=20 #port =3D 5432=20 #=20 unix_socket_directory =3D '/var/sockets'=20 #unix_socket_group =3D 'sockets'=20 #unix_socket_permissions =3D 0777 # octal=20 #virtual_host =3D '' # what interface to listen on; defaults to any=20 #rendezvous_name =3D '' # defaults to the computer name=20 postgres[14947]: [1-1] LOG: could not create IPv6 socket: Address family no= t supported by protocol=20 postgres[14947]: [2-1] FATAL: could not create semaphores: No space left on= device=20 postgres[14947]: [2-2] DETAIL: Failed system call was semget(5432018, 17, 0= 3600).=20 postgres[14947]: [2-3] HINT: This error does *not* mean that you have run o= ut of disk space.=20 postgres[14947]: [2-4] ^IIt occurs when either the system limit for the max= imum number of semaphore sets (SEMMNI), or the system wide maximum number o= f=20 postgres[14947]: [2-5] semaphores (SEMMNS), would be exceeded. You need to = raise the respective kernel parameter. Alternatively, reduce PostgreSQL's= =20 postgres[14947]: [2-6] consumption of semaphores by reducing its max_connec= tions parameter (currently 512).=20 postgres[14947]: [2-7] ^IThe PostgreSQL documentation contains more informa= tion about configuring your system for PostgreSQL.=20 postgres[14947]: [3-1] LOG: shmctl(25755662, 0, 0) failed: Invalid argument= =20 postgresql: failed=20 pg_dumpall > outfile pg_dumpall: could not connect to database "template1": could not connect to= server: No such file or directory=20 Is the server running locally and accepting=20 connections on Unix domain socket "/tmp/.s.PGSQL.5432"? postgres[13098]: [4-1] FATAL: could not open file "/var/lib/pgsql/data/glob= al/1262": Permission denied postgres[12961]: [8-1] LOG: could not open temporary statistics file "/var/= lib/pgsql/data/global/pgstat.tmp.12946": Permission denied=20 --=20 =D1 =F3=E2=E0=E6=E5=ED=E8=E5=EC, Sisyphus mailto:Sisyphus@mail.ru