From owner-freebsd-questions  Sat Apr  6 17: 5: 2 2002
Delivered-To: freebsd-questions@freebsd.org
Received: from hivemind.trini0.org (bgp626680bgs.brick201.nj.comcast.net [68.39.132.244])
	by hub.freebsd.org (Postfix) with SMTP id 38DCA37B400
	for <questions@FreeBSD.ORG>; Sat,  6 Apr 2002 17:04:58 -0800 (PST)
Received: (qmail 14636 invoked by uid 0); 7 Apr 2002 01:04:56 -0000
Received: from unknown (HELO trini0.org) (192.168.0.3)
  by hivemind.trini0.org with SMTP; 7 Apr 2002 01:04:56 -0000
Message-ID: <3CAF9B38.3060908@trini0.org>
Date: Sat, 06 Apr 2002 20:04:56 -0500
From: Gerard Samuel <gsam@trini0.org>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:0.9.9) Gecko/20020315
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: FreeBSD Questions <questions@FreeBSD.ORG>
Subject: Postgre database initialise??
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG

Im trying to install Postgresql from the ports.
It installed cleanly.
I edited /usr/local/pgsql/.profile and changed the data dir to ->
PGDATA=/files/www/pgdata/data

I created /files/www/pgdata/data and chowned it to pgsql:pgsql.

Then I try to run ->
hivemind# su -l pgsql -c initdb

And here is the output ->
hivemind# su -l pgsql -c initdb
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.

Fixing permissions on existing directory /files/www/pgdata/data... ok
creating directory /files/www/pgdata/data/base... ok
creating directory /files/www/pgdata/data/global... ok
creating directory /files/www/pgdata/data/pg_xlog... ok
creating directory /files/www/pgdata/data/pg_clog... ok
creating template1 database in /files/www/pgdata/data/base/1... Bad 
system call - core dumped

initdb failed.


Any tips would be appreciated.  Thanks.


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message