postgresql and initdb
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
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
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
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
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
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]