pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: ngaleyev@wavelengthmail.com
Cc: pgsql-admin@postgresql.org
Subject: Re: hot restart of posgtresql
Date: Tue, 03 Jul 2007 22:51:45 -0400
Message-ID: <17445.1183517505@sss.pgh.pa.us> (raw)
In-Reply-To: <20070704022944.GD6171@alvh.no-ip.org>
References: <1210.209.168.137.101.1183505726.squirrel@wavelengthmail.com>
	<16558.1183514240@sss.pgh.pa.us>
	<20070704022944.GD6171@alvh.no-ip.org>

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane wrote:
>> ngaleyev@wavelengthmail.com writes:
>>> heres my sysctl:
>>> kernel.shmmax=4294967296
>>> kernel.shmall=536870912
>> 
>> Why have you got SHMALL set to half a GB when you have Postgres
>> configured to ask for over 3 GB?

> Hmm, isn't shmall measured in pages?

Depends on platform, which he didn't say ... but if it is a platform
that measures in pages, I wonder whether that value is provoking an
integer overflow somewhere.  I don't think Linux allows more than
about 2 million, for instance.

> I think the problem may be that he changed the settings in sysctl.conf
> but he hasn't rebooted since, so the kernel is running with other
> settings.  Trying with sysctl -w to change the actual values might prove
> helpful.

But his DB *was* running before, so somehow the active sysctl settings
are different now than they were.  I was betting on there having been
a manual tweak to sysctl that never got made in the configuration file,
and thus got lost on reboot.

			regards, tom lane



view thread (5+ messages)  latest in thread

Message-ID: <17445.1183517505@sss.pgh.pa.us>
Permalink:  ../17445.1183517505@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/17445.1183517505@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, alvherre@commandprompt.com, ngaleyev@wavelengthmail.com
  Subject: Re: hot restart of posgtresql
  In-Reply-To: <17445.1183517505@sss.pgh.pa.us>

* 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