From owner-freebsd-questions@FreeBSD.ORG Wed Dec 31 15:33:00 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 DF340106566B for ; Wed, 31 Dec 2008 15:32:59 +0000 (UTC) (envelope-from odhiambo@gmail.com) Received: from mail-bw0-f19.google.com (mail-bw0-f19.google.com [209.85.218.19]) by mx1.freebsd.org (Postfix) with ESMTP id 56BE38FC16 for ; Wed, 31 Dec 2008 15:32:59 +0000 (UTC) (envelope-from odhiambo@gmail.com) Received: by mail-bw0-f19.google.com with SMTP id 12so15456641bwz.19 for ; Wed, 31 Dec 2008 07:32:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=+oQmPKRUOqYW+dQdomkL8y2+H9T1fp+CVPH8+UM6Wxg=; b=UmZiYPBGN5TCwkIKbtCA3yhf4ct1d5V/pZoxlM74cd7K/q7Gp+yWiw7sM5TTYnI6Kj NKjjdj+YsRWFQe4u7UJDEmi5EtcrVZ3oTwVGlhYlWZlbtEOkTK2XLRqibQiekedNjuEv QVlfCR8gLnNRTJvehkYC9omjYVV3FeJmLSq9Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=ai5Wbgxvqc28vZdXzd2LuMs5J0Dtl1tyqmhToLikf+RLSVaPA1GeZoGKLirbUYyKj5 960l4LWW6hRxNGoEyZ8JUdoPFAAoYFaskBth7eEyIYvaWRA/AaOGsHfnb3XvH9l8f4g2 A2X9iCgpREOvCKvKGp5NgatGSh491OYkOG4Os= Received: by 10.181.201.18 with SMTP id d18mr6081465bkq.125.1230737578237; Wed, 31 Dec 2008 07:32:58 -0800 (PST) Received: by 10.181.9.10 with HTTP; Wed, 31 Dec 2008 07:32:58 -0800 (PST) Message-ID: <991123400812310732s5f23c072k18571437d9239c84@mail.gmail.com> Date: Wed, 31 Dec 2008 18:32:58 +0300 From: "Odhiambo Washington" To: "Andrew Gould" In-Reply-To: MIME-Version: 1.0 References: <20081231150648.GA18063@teddy.fas.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Free BSD Questions list 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 15:33:00 -0000 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. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ "The way my luck is running, if I was a politician I would be honest." Rodney Dangerfield