pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joe Barwell <jbar@es.co.nz>
Cc: pgsql-admin@postgresql.org
Subject: Re: initdb problem
Date: Thu, 21 Jun 2007 19:12:48 -0700
Message-ID: <467B3020.2020702@commandprompt.com> (raw)
In-Reply-To: <10580.1182478082@sss.pgh.pa.us>
References: <467b280e.26e.6f03.423851873@ihug.co.nz>
	<10580.1182478082@sss.pgh.pa.us>

Tom Lane wrote:
> Joe Barwell <jbar@es.co.nz> writes:
>> I get the same result trying  to initdb after rebooting, the
>> end of which is:
>> /Library/PostgreSQL8/data/base/1 ... FATAL:  could not
>> create shared memory segment: Cannot allocate memory
>> DETAIL:  Failed system call was shmget(key=2, size=1646592,
>> 03600).
>> HINT:  This error usually means that PostgreSQL's request
>> for a shared memory segment exceeded available memory or
>> swap space.
> 
> Hmph.  That is definitely not a SHMMAX violation (you get "Invalid
> argument" for that).  AFAIK the only two causes are SHMALL violation
> (which, since your SHMMAX and SHMALL are effectively the same, means
> someone is already eating part of SHMALL); or that you actually have not
> got enough RAM to allocate the shmem segment.  Which does not seem real
> probable, for a mere 1.6MB.  So I'm thinking something somewhere is
> allocating a shmem segment behind your back.  Maybe those earlier
> "failed" attempts actually did install a working Postgres server?
> You should troll through the "ps" listing carefully.

Doesn't MacOSX install postgresql by default for one of their management 
services?

Joshua D. Drake
-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/




view thread (26+ messages)  latest in thread

Message-ID: <467B3020.2020702@commandprompt.com>
Permalink:  ../467B3020.2020702@commandprompt.com/
Also on:    postgresql.org/message-id/467B3020.2020702@commandprompt.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: jd@commandprompt.com, tgl@sss.pgh.pa.us, jbar@es.co.nz
  Subject: Re: initdb problem
  In-Reply-To: <467B3020.2020702@commandprompt.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