pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sisyphus@mail.ru
To: pgsql-admin@postgresql.org
Subject: posgresql AltLinux
Date: Wed, 10 May 2006 23:45:52 +0400
Message-ID: <1735235158.20060510234552@mail.ru> (raw)

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

# 
tcpip_socket = true 
max_connections = 512# 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 

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"?


postgres[13098]: [4-1] FATAL: could not open file "/var/lib/pgsql/data/global/1262": Permission denied
postgres[12961]: [8-1] LOG: could not open temporary statistics file "/var/lib/pgsql/data/global/pgstat.tmp.12946": Permission denied 







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




Message-ID: <1735235158.20060510234552@mail.ru>
Permalink:  ../1735235158.20060510234552@mail.ru/
Also on:    postgresql.org/message-id/1735235158.20060510234552@mail.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Sisyphus@mail.ru
  Subject: Re: posgresql AltLinux
  In-Reply-To: <1735235158.20060510234552@mail.ru>
  References: <1735235158.20060510234552@mail.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox