thanks for the heads up about the pg_config stuff... I wondered about
the difference.....I have several boxes that were installed via ports
(which have the binaries reside in /usr/local/pgsql) and some hand
installed from the tar (which are in usr/local/bin).
At least that explains why I have binaries in 2 different places!!
Thanks again....(my problem was that I needed to restart the postmaster....)
Jeff
Jan Wieck wrote:
> You try to install 7.4.5 from souces over the FreeBSD Port build. The
> problem is that the options to configure need to be the same. You can
> see the options the port maintainer used by running the original
> pg_config with --configure option.
>
> What you have done so far and what you should undo is that you
> installed a whole bunch of stuff in /usr/local/pgsql, which is an
> unusual location for FreeBSD.
>
> Then you run the configure for 7.4.5 with exactly the same options, do
> a "gmake clean all" and as root "gmake install install-all-headers".
> Then you restart the postmaster and are in business.
>
>
> Jan