From owner-freebsd-ports  Sat Oct  4 14:55:21 1997
Return-Path: <owner-freebsd-ports>
Received: (from root@localhost)
          by hub.freebsd.org (8.8.7/8.8.7) id OAA08912
          for ports-outgoing; Sat, 4 Oct 1997 14:55:21 -0700 (PDT)
Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1])
          by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id OAA08906;
          Sat, 4 Oct 1997 14:55:12 -0700 (PDT)
Received: from localhost (jfieber@localhost)
	by fallout.campusview.indiana.edu (8.8.7/8.8.7) with SMTP id QAA05805;
	Sat, 4 Oct 1997 16:54:32 -0500 (EST)
Date: Sat, 4 Oct 1997 16:54:32 -0500 (EST)
From: John Fieber <jfieber@indiana.edu>
To: Andreas Klemm <andreas@klemm.gtn.com>
cc: scrappy@FreeBSD.ORG, ports@FreeBSD.ORG
Subject: Re: Postgresql 6.2
In-Reply-To: <19971004220940.20920@klemm.gtn.com>
Message-ID: <Pine.BSF.3.96.971004164251.308C-100000@fallout.campusview.indiana.edu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-ports@FreeBSD.ORG
X-Loop: FreeBSD.org
Precedence: bulk

On Sat, 4 Oct 1997, Andreas Klemm wrote:

> > The script which didn't work has...
> > 
> >   $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $
> 
> BTW, with that version I have success here on a -current
> system. postmaster is up and running:
> 
> pgsql     237  0.0  0.2  1148  144  ??  Is    5:03PM   0:00.03 /usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data -S -o -F (postgres)

I get the same thing from ps, but for some reason the -D flag is
completely ignored.  Try copying the data directory somewhere
else, change the -D flag accordingly, then do a "createdb foo".
Where does the new "foo" database show up?  On 2.2.2 with the
above startup script it still shows up in /usr/local/pgsql/data,
not the specified directory.

BUT, it works fine if I echo the command to su.  Maybe some su
quirk? 

-john