From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joe Barwell <jbar@es.co.nz>
Cc: pgsql-admin@postgresql.org
Subject: Re: initdb problem
Date: Thu, 21 Jun 2007 22:08:02 -0400
Message-ID: <10580.1182478082@sss.pgh.pa.us> (raw)
In-Reply-To: <467b280e.26e.6f03.423851873@ihug.co.nz>
References: <467b280e.26e.6f03.423851873@ihug.co.nz>
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.
We're really seriously handicapped here by not having ipcs handy :-(.
I wonder whether it is available anywhere for 10.3.9?
> Does the size=1646592 bit mean it's ignoring my
> /etc/sysctl.conf file?
Well, the sysctl -a thing prints out the active settings, and they
are more than that.
> Not even sure if a g4 will run 10.4.x, will it?
Certainly. I'm typing on one right now (g4 laptop actually). Heck,
I've got 10.4 running on a Cube upstairs. (Well, "run" might be
overly kind; the GUI is a bit sluggish due to lack of RAM. But it
works perfectly well as a server.)
regards, tom lane
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, jbar@es.co.nz
Subject: Re: initdb problem
In-Reply-To: <10580.1182478082@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