From owner-freebsd-questions@FreeBSD.ORG  Wed Dec 31 15:06:50 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 43D49106566C
	for <freebsd-questions@freebsd.org>;
	Wed, 31 Dec 2008 15:06:50 +0000 (UTC) (envelope-from stanb@panix.com)
Received: from mail2.panix.com (mail2.panix.com [166.84.1.73])
	by mx1.freebsd.org (Postfix) with ESMTP id 179748FC12
	for <freebsd-questions@freebsd.org>;
	Wed, 31 Dec 2008 15:06:49 +0000 (UTC) (envelope-from stanb@panix.com)
Received: from mailbackend.panix.com (mailbackend.panix.com [166.84.1.89])
	by mail2.panix.com (Postfix) with ESMTP id 4C1883480D
	for <freebsd-questions@freebsd.org>;
	Wed, 31 Dec 2008 10:06:49 -0500 (EST)
Received: from teddy.fas.com (c-76-26-198-188.hsd1.sc.comcast.net
	[76.26.198.188])
	by mailbackend.panix.com (Postfix) with ESMTP id 2979BEF79
	for <freebsd-questions@freebsd.org>;
	Wed, 31 Dec 2008 10:06:49 -0500 (EST)
Received: from stan by teddy.fas.com with local (Exim 3.36 #1 (Debian))
	id 1LI2em-0004k4-00
	for <freebsd-questions@freebsd.org>; Wed, 31 Dec 2008 10:06:48 -0500
Date: Wed, 31 Dec 2008 10:06:48 -0500
From: stan <stanb@panix.com>
To: Free BSD Questions list <freebsd-questions@freebsd.org>
Message-ID: <20081231150648.GA18063@teddy.fas.com>
Mail-Followup-To: Free BSD Questions list <freebsd-questions@freebsd.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-Editor: gVim
X-Operating-System: Debian GNU/Linux
X-Kernel-Version: 2.4.23
X-Uptime: 10:01:15 up 233 days, 16:23, 1 user, load average: 0.03, 0.02, 0.02
User-Agent: Mutt/1.5.4i
Sender: Stan Brown <stanb@panix.com>
Subject: PostgreSQL setup
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: Wed, 31 Dec 2008 15:06:50 -0000

I have installed PostgreSQL via the ports on a new 7.1 machine. I am trying
to set it up.

I found:

http://www.freebsddiary.org/postgresql.php

Whic says to run:

 su -l pgsql -c initdb

But that gives me the following error message:

initdb: no data directory specified
You must identify the directory where the data for this database system
will reside.  Do this with either the invocation option -D or the
environment variable PGDATA.

But when I try:

#  su -l pgsql -c initdb -D /usr/local/postgres

I get:

Illegal option -D

What am I doing wrong?

-- 
One of the main causes of the fall of the roman empire was that, lacking
zero, they had no way to indicate successful termination of their C
programs.