From: Christopher R. Jones <cj@interlog.com>
To: pgsql-admin@postgresql.org
Subject: postmaster failure
Date: Thu, 03 Feb 2000 14:50:58 -0500
Message-ID: <3.0.32.20000203145057.009fa730@mail.interlog.com> (raw)
I installed postgres-6.5 on Solaris 7, Intel - Pentium Pro, 128 MByte Ram.
I used gcc-2.95.1 and gnu make. The program compiled installed fine but
postmaster failed:
cr-jay.com% initdb
We are initializing the database system with username postgres (uid=1003).
This user will own all the files and must also own the server process.
Creating Postgres database system directory /usr/local/pgsql/data
Creating Postgres database system directory /usr/local/pgsql/data/base
Creating template database in /usr/local/pgsql/data/base/template1
Creating global classes in /usr/local/pgsql/data/base
Adding template1 database to pg_database...
Vacuuming template1
Creating public pg_user view
Creating view pg_rules
Creating view pg_views
Creating view pg_tables
Creating view pg_indexes
Loading pg_description
cr-jay.com% postmaster -i
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
size=1063936, permission=600
FATAL 1: ShmemCreate: cannot create region
So then, after reading in the faq, I edited the /etc/system file to add:
set shmsys:shminfo_shmmax=1048567
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100
I now get:
cr-jay.com% postmaster -i
IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
permission=700
IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
size=120, permission=0
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment
I played with the segment max size to no avail.
Any ideas?
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@interlog.com
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: cj@interlog.com
Subject: Re: postmaster failure
In-Reply-To: <3.0.32.20000203145057.009fa730@mail.interlog.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