pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: ngaleyev@wavelengthmail.com
To: pgsql-admin@postgresql.org
Subject: hot restart of posgtresql
Date: Tue, 3 Jul 2007 19:35:26 -0400 (EDT)
Message-ID: <1210.209.168.137.101.1183505726.squirrel@wavelengthmail.com> (raw)

hi all
by unknown reason our database server rebooted couple hours ago.
now i cannot restart posgresql 8.1
heres the error code i get:


=====================================================
root@eddie:/var/run# /etc/init.d/postgresql-8.1 start
Starting PostgreSQL 8.1 database server: mainThe PostgreSQL server failed
to start. Please check the log output:
2007-07-03 19:20:42 EDT  2928 FATAL:  could not create shared memory
segment: Invalid argument
2007-07-03 19:20:42 EDT  2928 DETAIL:  Failed system call was
shmget(key=5432001, size=3276259328, 03600).
2007-07-03 19:20:42 EDT  2928 HINT:  This error usually means that
PostgreSQL's request for a shared memory segment exceeded your kernel's
SHMMAX parameter.  You can either reduce the request size or reconfigure
the kernel with larger SHMMAX.  To reduce the request size (currently
3276259328 bytes), reduce PostgreSQL's shared_buffers parameter (currently
393216) and/or its max_connections parameter (currently 250).
        If the request size is already small, it's possible that it is
less than your kernel's SHMMIN parameter, in which case raising
the request size or reconfiguring SHMMIN is called for.
        The PostgreSQL documentation contains more information about
shared memory configuration.
 failed!
=======================================================

heres my sysctl:
kernel.shmmax=4294967296
kernel.shmall=536870912


Any help will be really appreciated
Thanks





view thread (5+ messages)  latest in thread

Message-ID: <1210.209.168.137.101.1183505726.squirrel@wavelengthmail.com>
Permalink:  ../1210.209.168.137.101.1183505726.squirrel@wavelengthmail.com/
Also on:    postgresql.org/message-id/1210.209.168.137.101.1183505726.squirrel@wavelengthmail.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ngaleyev@wavelengthmail.com
  Subject: Re: hot restart of posgtresql
  In-Reply-To: <1210.209.168.137.101.1183505726.squirrel@wavelengthmail.com>

* 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