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

Collapse
1: compiling nspostgres3.0 on Mac OS X
Posted by Christian Foerster on 07/20/01 02:58 AM
Hi,

has anyone here successfuly build the postgres driver for aolserver on OS X (10.0.4)? I always get an "cc: cannot specify -o with -c or -S and multiple compilations make: *** [nspostgres.o] Error 1".

I'm using aolserver3.4 (binary distribution for Darwin-PPC) and Postgres 7.1.2. I've downloaded the nspostgres3.0 source and changed the Makefile to the follwing - please take a lock at the end of the mail.

Anyone has a guess? Are there other OS X users, that are successfuly using openacs, aolserver and postgres on OS X?

Thanks for any help.

Chris

################
#
# $Header: /cvsroot/aolserver/nspostgres/Makefile,v 1.2 2000/08/20 16:12:48 kriston Exp
$
#
# nspostgres --
#
#      Postgres internal database driver.

NSHOME    =  /usr/local/aolserver

# Module name

MOD      =  nspostgres.so

# Objects to build.

OBJS      =  nspostgres.o

# Extra libraries

MODLIBS  =  /usr/local/pgsql/lib -lpq

# Extra compiler flags

CFLAGS    =  /usr/local/pgsql/include

include $(NSHOME)/include/Makefile.module

Collapse
2: Response to compiling nspostgres3.0 on Mac OS X (response to 1)
Posted by Walter McGinnis on 07/20/01 11:27 PM
I have OpenACS 4, pg-driver 2.0, PostgreSQL 7.1.2, and
AOLserver 3.3+aD13 working on Mac OS 10.0.4.  I've compiled a
very rough howto.  It's not quite ready to go up on a public site
yet, but I do need some feedback.  I'll send you a copy via a privat
e email.
Collapse
3: Response to compiling nspostgres3.0 on Mac OS X (response to 1)
Posted by Erik Swedberg on 07/21/01 11:01 PM
I've got macOSX 10.0.4 and I'd like to get OpenACS 4 up and
running. I'd be interested in seeing your "How-To" also.

Thanks!

Collapse
4: Response to compiling nspostgres3.0 on Mac OS X (response to 1)
Posted by Walter McGinnis on 09/17/01 12:58 AM
See this thread (https://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0002mP&topic_id=OpenACS&topic=11) for
information on the new OpenACS 4 on Mac OS X (and Darwin)
document.

Enjoy,

Collapse
5: Response to compiling nspostgres3.0 on Mac OS X (response to 1)
Posted by Jamie Ross on 01/18/02 05:48 PM
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