From owner-freebsd-questions@FreeBSD.ORG Wed Oct 17 22:01:37 2007 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 C37AC16A418 for ; Wed, 17 Oct 2007 22:01:37 +0000 (UTC) (envelope-from perrin@apotheon.com) Received: from outbound-mail-35.bluehost.com (outbound-mail-35.bluehost.com [69.89.18.155]) by mx1.freebsd.org (Postfix) with SMTP id 9CB8C13C494 for ; Wed, 17 Oct 2007 22:01:37 +0000 (UTC) (envelope-from perrin@apotheon.com) Received: (qmail 22881 invoked by uid 0); 17 Oct 2007 21:36:54 -0000 Received: from unknown (HELO box183.bluehost.com) (69.89.25.183) by mailproxy2.bluehost.com with SMTP; 17 Oct 2007 21:36:54 -0000 Received: from c-24-9-123-251.hsd1.co.comcast.net ([24.9.123.251] helo=demeter.hydra) by box183.bluehost.com with esmtps (TLSv1:AES256-SHA:256) (Exim 4.68) (envelope-from ) id 1IiGZS-0007cj-75 for freebsd-questions@freebsd.org; Wed, 17 Oct 2007 15:36:54 -0600 Received: from demeter.hydra (localhost [127.0.0.1]) by demeter.hydra (8.13.6/8.13.6) with ESMTP id l9HLbQXN024043 for ; Wed, 17 Oct 2007 15:37:27 -0600 (MDT) (envelope-from perrin@apotheon.com) Received: (from ren@localhost) by demeter.hydra (8.13.6/8.13.6/Submit) id l9HLbQ7k024042 for freebsd-questions@freebsd.org; Wed, 17 Oct 2007 15:37:26 -0600 (MDT) (envelope-from perrin@apotheon.com) X-Authentication-Warning: demeter.hydra: ren set sender to perrin@apotheon.com using -f Date: Wed, 17 Oct 2007 15:37:26 -0600 From: Chad Perrin To: FreeBSD Questions Message-ID: <20071017213726.GD23383@demeter.hydra> Mail-Followup-To: FreeBSD Questions References: <20071017190216.GA23322@demeter.hydra> <8B8EF8F5-86EE-4929-B5E7-93660FB212D2@mac.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8B8EF8F5-86EE-4929-B5E7-93660FB212D2@mac.com> User-Agent: Mutt/1.4.2.3i X-Identified-User: {737:box183.bluehost.com:apotheon:apotheon.net} {sentby:bopbeforesmtp 24.9.123.251 authed with apotheon.com} X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - box183.bluehost.com X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [737 12] / [47 12] X-AntiAbuse: Sender Address Domain - apotheon.com Subject: Re: postgresql and initdb 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, 17 Oct 2007 22:01:37 -0000 On Wed, Oct 17, 2007 at 12:11:24PM -0700, Chuck Swiger wrote: > On Oct 17, 2007, at 12:02 PM, Chad Perrin wrote: > >I've installed PostgreSQL here on FreeBSD 6.2-RELEASE, and I'm a > >little > >confused by the presence of the initdb(1) manpage and absence of an > >initdb command. > > > > # locate initdb > > /usr/local/man/man1/initdb.1.gz > > /usr/ports/databases/postgresql73-server/files/patch-src-bin- > >initdb-Makefile > > /usr/ports/databases/postgresql74-server/files/patch-src-bin- > >initdb-Makefile > > /usr/ports/www/rt2/files/patch-tools-initdb > > > >Any hints? > > This: > > % head /usr/ports/databases/postgresql74-server/pkg-plist-server > bin/initdb > bin/initlocation > bin/ipcclean > bin/pg_controldata > bin/pg_ctl > bin/pg_id > bin/pg_resetxlog > bin/postgres > bin/postmaster > etc/periodic/daily/502.pgsql > > ...suggests it will be put in /usr/local/bin/initdb (modulo $ > {LOCALBASE}, if changed)-- try doing a rehash if needed. :-) It's not there, unfortunately. The above locate indicated as much, and `cd /usr/local/bin;ls|grep initdb` returns nothing (as does simply ls and searching through it by eye). Similarly, that location doesn't contain initlocation, pg_controldata, pg_ctl, pg_id, pg_resetxlog, postgres, or postmaster. Thus . . . rehashing (which I did before I ran the locate anyway) probably won't work. -- CCD CopyWrite Chad Perrin [ http://ccd.apotheon.org ] Dr. Ron Paul: "Liberty has meaning only if we still believe in it when terrible things happen and a false government security blanket beckons."