postgresql and initdb

2007-10-17 Thread Chad Perrin
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?

-- 
CCD CopyWrite Chad Perrin [ http://ccd.apotheon.org ]
Phillip J. Haack: Productivity is not about speed. It's about velocity.
You can be fast, but if you're going in the wrong direction, you're not
helping anyone.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: postgresql and initdb

2007-10-17 Thread Chuck Swiger

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


--
-Chuck

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: postgresql and initdb

2007-10-17 Thread Chuck Swiger

On Oct 17, 2007, at 2:37 PM, Chad Perrin wrote:

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


Odd-- that sounds like the port wasn't installed properly.  What does:

  pkg_info | grep postgres

...show?  And pkg_info -Lx postgres...?

--
-Chuck

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: postgresql and initdb

2007-10-17 Thread Erik Cederstrand

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?


Use the rc.d script:

/usr/local/etc/rc.d/postgres initdb

(At least for postgres 8.2)

Erik


___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: postgresql and initdb

2007-10-17 Thread 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


pgp1pb4UnI14f.pgp
Description: PGP signature


Re: postgresql and initdb

2007-10-17 Thread Chad Perrin
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.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]