From owner-freebsd-questions@FreeBSD.ORG Wed Oct 17 22:12:51 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 42EC216A417 for ; Wed, 17 Oct 2007 22:12:51 +0000 (UTC) (envelope-from josh@tcbug.org) Received: from conn-smtp.mc.mpls.visi.com (conn.mc.mpls.visi.com [208.42.156.2]) by mx1.freebsd.org (Postfix) with ESMTP id 1E2F313C46A for ; Wed, 17 Oct 2007 22:12:50 +0000 (UTC) (envelope-from josh@tcbug.org) Received: from mail.tcbug.org (mail.tcbug.org [208.42.70.163]) by conn-smtp.mc.mpls.visi.com (Postfix) with ESMTP id 51885786A for ; Wed, 17 Oct 2007 17:12:50 -0500 (CDT) Received: by mail.tcbug.org (Postfix, from userid 1001) id 0673710AA891; Wed, 17 Oct 2007 17:12:50 -0500 (CDT) Date: Wed, 17 Oct 2007 17:12:49 -0500 From: Josh Paetzel To: FreeBSD Questions Message-ID: <20071017221249.GC4814@tcbug.org> Mail-Followup-To: FreeBSD Questions References: <20071017190216.GA23322@demeter.hydra> <8B8EF8F5-86EE-4929-B5E7-93660FB212D2@mac.com> <20071017213726.GD23383@demeter.hydra> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="DIOMP1UsTsWJauNi" Content-Disposition: inline In-Reply-To: <20071017213726.GD23383@demeter.hydra> User-Agent: Mutt/1.5.16 (2007-06-09) Subject: Re: postgresql and initdb X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Josh Paetzel List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 17 Oct 2007 22:12:51 -0000 --DIOMP1UsTsWJauNi Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Chad Perrin wrote: > 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 =20 > > >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-=20 > > >initdb-Makefile > > > /usr/ports/databases/postgresql74-server/files/patch-src-bin-=20 > > >initdb-Makefile > > > /usr/ports/www/rt2/files/patch-tools-initdb > > > > > >Any hints? > >=20 > > This: > >=20 > > % 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 > >=20 > > ...suggests it will be put in /usr/local/bin/initdb (modulo $=20 > > {LOCALBASE}, if changed)-- try doing a rehash if needed. :-) >=20 > 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). >=20 > Similarly, that location doesn't contain initlocation, pg_controldata, > pg_ctl, pg_id, pg_resetxlog, postgres, or postmaster. >=20 > Thus . . . rehashing (which I did before I ran the locate anyway) > probably won't work. >=20 What port did you install exactly? Installing one of the postgresql[XX]-client ports will end you up with all of the manpages, but none of the commands that you would only need if there was a server installed, such as initdb, postgres, postmaster and so on and so forth. My guess is you need to install the corrosponding postgresql[XX]-server to match the client you already have installed. --=20 Thanks, Josh Paetzel --DIOMP1UsTsWJauNi Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFHFojhJvkB8SevrssRAglUAJ9LvSNJdRRNV2qwoWVTLKJ98I7aQgCgjc5/ 6emX/skJZ8mLVrfQ3SCk7/M= =so1n -----END PGP SIGNATURE----- --DIOMP1UsTsWJauNi--