Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 71EC29FB52F for ; Tue, 3 Jul 2007 20:59:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14750-10 for ; Tue, 3 Jul 2007 20:59:04 -0300 (ADT) X-Greylist: delayed 00:23:53.65734 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 5273A9FB310 for ; Tue, 3 Jul 2007 20:59:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.wavelengthmail.com (mail.wavelengthmail.com [208.65.225.2]) by svr4.postgresql.org (Postfix) with ESMTP id 117725AF03B for ; Tue, 3 Jul 2007 23:35:06 +0000 (GMT) Received: from wavelengthmail.com (secure.gowavelength.com [208.65.225.4]) by mail.wavelengthmail.com (wavelengthmail.com) with ESMTP id 360632FBBB for ; Tue, 3 Jul 2007 19:34:55 -0400 (EDT) Received: from 209.168.137.101 (SquirrelMail authenticated user ngaleyev@wavelengthmail.com) by wavelengthmail.com with HTTP; Tue, 3 Jul 2007 19:35:26 -0400 (EDT) Message-ID: <1210.209.168.137.101.1183505726.squirrel@wavelengthmail.com> Date: Tue, 3 Jul 2007 19:35:26 -0400 (EDT) Subject: hot restart of posgtresql From: ngaleyev@wavelengthmail.com To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.5.1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.097 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135, NO_REAL_NAME=0.961 X-Spam-Level: * X-Archive-Number: 200707/25 X-Sequence-Number: 26006 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