Forum OpenACS Q&A: Response to compiling nspostgres3.0 on Mac OS X

Collapse
Posted by Jamie Ross on
Okay, I just completed a successful build of Postgresql 7.1.3 with TCL,Python and ODBC support which was more work than I expected but here is what I did: I have a lot of stuff in /sw which I think is where Developer tools dumped things
 
1.  apply patch to base 7.1 3 distribution.  This fixes the flat_namespace link and adds posix fixes 
http://members.blackbox.net/a/files/postgresql-7.1.3-posix.patch 
(see http://www.entropy.ch/software/macosx/postgresql/ for more info) 
 
2. copy tcl and tk header files from /sw/include into postgres-7.1.3/src/include 
 
3. fix link options Makefile src/interface/python to include -flat_namespace 
LDSHARED=       $(CC) $(LDFLAGS) -bundle -flat_namespace -undefined suppress 
I think this is all the fixes it took. Unfortunately pgaccess (which was one point of this exercise) compiles but doesnt run .
 
Error in startup script: couldn't load file "/usr/local/pgsql/lib/libpgtcl": dynamic loading is not currently available on this system 
The bright side is that there are several PostgreSQL clients for MacOSX (MacSQL,ProSQL,pgMac). So far ProSQL seems the best and $89 is not too steep even if it cant do what pgaccess does

cheers Jamie