postgresql and initdb

Chad Perrin perrin at apotheon.com
Wed Oct 17 15:01:37 PDT 2007


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


More information about the freebsd-questions mailing list