Forum OpenACS Q&A: FreeBSD, nspostgres compilation problems

1: FreeBSD, nspostgres compilation problems

Posted by Hao Ngo on 12/30/01 12:47 AM

I just installed FreeBSD 4.4 from CD with Postgres 7.1.3
I downloaded the FreeBSD Aolserver binaries off the web.
I downloaded the nspostgres source, but I am getting compilation
errors because the POSTGRES environment variable isn't set. The
problem is I don't know where the postgres libraries are and I am
not even sure if the client side libraries for postgres are
installed or even if this is the problem.

Can I get the binaries of nspostgres from somewhere or do I need to
compile them from scratch? I've always done this under Linux.
First time under FreeBSD, although it appears very similar...

Any help would be greatly appreciated...

Thanks,
Hao.

2: Response to FreeBSD, nspostgres compilation problems (response to 1)

Posted by Marc Spitzer on 12/30/01 01:03 AM

Hello,

the postgres libs are in /usr/local/lib, on my box. If you type 'ldd /path/to/psql' it should tell you where pg's libs are. There is a freebsd install doc around that will walk you trough a source install, I forget the author. Another thing I would recomend is to upgrade your system to the latest source and rebuild it.

good luck

3: Response to FreeBSD, nspostgres compilation problems (response to 1)

Posted by Vinod Kurup on 12/30/01 03:22 AM

The guide is written by Gilbert Wong and it's located at http://www.orchardlabs.com/freebsd/. It will likely be included in the standard OpenACS documentation in the near future.

The other issue is that you might have the wrong postgres driver. There are 2 PG drivers floating around - the nspostgres.so driver which is available from AOLserver.com and the postgres.so driver that is available from openacs.org. You want the postgres.so driver, not the nspostgres.so one.

Good luck!