From owner-freebsd-questions@FreeBSD.ORG  Thu Jan  5 20:44:33 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: questions@freebsd.org
Delivered-To: freebsd-questions@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 4B15216A41F
	for <questions@freebsd.org>; Thu,  5 Jan 2006 20:44:33 +0000 (GMT)
	(envelope-from mike.jeays@rogers.com)
Received: from smtp108.rog.mail.re2.yahoo.com (smtp108.rog.mail.re2.yahoo.com
	[68.142.225.206])
	by mx1.FreeBSD.org (Postfix) with SMTP id AC75F43D55
	for <questions@freebsd.org>; Thu,  5 Jan 2006 20:44:32 +0000 (GMT)
	(envelope-from mike.jeays@rogers.com)
Received: (qmail 46785 invoked from network); 5 Jan 2006 20:44:32 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rogers.com;
	h=Received:Subject:From:To:Content-Type:Date:Message-Id:Mime-Version:X-Mailer:Content-Transfer-Encoding;
	b=wG4IM3Wqt6CMQ2t1aADC3JjaR+490g/5j5yr06G+L6hdvCyZ2SfvGBlH4HXNwORUiN02xV4XkQIWRNjC3SsoTmTMkKhVUYRLdDrekurGBxGiuG2aBHJ3pgGE3i0zQmboWH6GNG/wTMhVRq76xhPEjlEXYbLESdb5xTa/6trK3Yc=
	; 
Received: from unknown (HELO chaucer.jeays.ca)
	(mike.jeays@rogers.com@72.139.51.96 with plain)
	by smtp108.rog.mail.re2.yahoo.com with SMTP; 5 Jan 2006 20:44:31 -0000
From: Mike Jeays <mike.jeays@rogers.com>
To: questions@freebsd.org
Content-Type: text/plain
Date: Thu, 05 Jan 2006 15:44:30 -0500
Message-Id: <1136493870.1989.24.camel@chaucer.jeays.ca>
Mime-Version: 1.0
X-Mailer: Evolution 2.2.1.1 FreeBSD GNOME Team Port 
Content-Transfer-Encoding: 7bit
Cc: 
Subject: Postgresql 8.0 again
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 05 Jan 2006 20:44:33 -0000

I just re-installed postgresql80-server from the ports, and get exactly
the same error as from the package.  This is on my 5.4 machine, were I
previously had a working copy.

I have tried changing max_connections in the sample config file (setting
it down to 1 just to see if even that would work). I also tried the
following kernel setting changes (without a reboot), with no
improvement.

sysctl -w kern.ipc.shmall=32768
sysctl -w kern.ipc.shmmax=134217728
sysctl -w kern.ipc.semmap=256

Error message from initdb

...
...
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... FATAL:
could not create semaphores: No space left on device
DETAIL:  Failed system call was semget(1, 17, 03600).
HINT:  This error does *not* mean that you have run out of disk space.
        It occurs when either the system limit for the maximum number of
semaphore sets (SEMMNI), or the system wide maximum number of semaphores
(SEMMNS), would be exceeded.  You need to raise the respective kernel
parameter.  Alternatively, reduce PostgreSQL's consumption of semaphores
by reducing its max_connections parameter (currently 10).
        The PostgreSQL documentation contains more information about
configuring your system for PostgreSQL.
child process exited with exit code 1
initdb: removing data directory "/usr/local/pgsql/data"

Any more help will be very welcome!