posgresql AltLinux

From: Sisyphus(at)mail(dot)ru
To: pgsql-admin(at)postgresql(dot)org
Subject: posgresql AltLinux
Date: 2006-05-10 19:45:52
Message-ID: 1735235158.20060510234552@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)mail(dot)ru

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2006-05-10 19:57:24 Re: limiting number of connections from specific host or by user
Previous Message mcelroy, tim 2006-05-10 19:43:19 Re: backups