From owner-freebsd-questions@FreeBSD.ORG Wed Dec 31 19:55:19 2008 Return-Path: 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 041A81065672 for ; Wed, 31 Dec 2008 19:55:19 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from mail.rachie.is-a-geek.net (rachie.is-a-geek.net [66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id C69B38FC19 for ; Wed, 31 Dec 2008 19:55:18 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from localhost (mail.rachie.is-a-geek.net [192.168.2.101]) by mail.rachie.is-a-geek.net (Postfix) with ESMTP id 53EADAFBC02; Wed, 31 Dec 2008 10:55:18 -0900 (AKST) From: Mel To: freebsd-questions@freebsd.org Date: Wed, 31 Dec 2008 10:55:17 -0900 User-Agent: KMail/1.9.10 References: <20081231150648.GA18063@teddy.fas.com> <991123400812310732s5f23c072k18571437d9239c84@mail.gmail.com> In-Reply-To: <991123400812310732s5f23c072k18571437d9239c84@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200812311055.17889.fbsd.questions@rachie.is-a-geek.net> Cc: Odhiambo Washington , Andrew Gould Subject: Re: PostgreSQL setup X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 31 Dec 2008 19:55:19 -0000 On Wednesday 31 December 2008 06:32:58 Odhiambo Washington wrote: > On Wed, Dec 31, 2008 at 6:15 PM, Andrew Gould wrote: > > On Wed, Dec 31, 2008 at 9:06 AM, stan wrote: > > > 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. > > Go into the port directory for postgresql71 and so "make deinstall". After > that, do > > script -a ~/PGSQL-INSTALL.txt make install clean > > Once that is done, go ito the ~/PGSQL-INSTALL.txt and read the lines > towards the bottom. Those are sometimes calles Post-install message. They > tell you exactly what to do on FreeBSD. Erm, that's kind of a round-about way to accomplish: cat /usr/local/share/doc/postgresql/README-server or: cat /var/db/pkg/postgresql-server*/+DISPLAY -- Mel Problem with today's modular software: they start with the modules and never get to the software part.