postgresql and initdb

[Josh Paetzel]

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  
> > >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.
> 

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.

-- 
Thanks,

Josh Paetzel
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20071017/62b6f1c3/attachment.pgp