[Pythonmac-SIG] Python Postgresql support?

[Tony McDonald]

Not a general response, this is really focussing on pyscopg.

psycopg is, shall we say, not the easiest module to compile up...

I had to do this to make it all happen... (a bash shell)

[544][tonymcd at eagle : Thu Aug 26 10:05]  ~/python/psycopg-1.1.15
% LIBS='-lcrypto -lssl' ./configure  
--with-postgres-includes=/usr/local/pgsql/include  
--with-postgres-libraries=/usr/local/pgsql/lib   
--with-mxdatetime-includes=../egenix-mx-base-2.0.4/mx/DateTime/ 
mxDateTime/
checking for python... /usr/bin/python
checking python version... 2.3
checking python installation prefix...  
/System/Library/Frameworks/Python.framework/Versions/2.3
checking python installation exec_prefix...  
/System/Library/Frameworks/Python.framework/Versions/2.3
checking definitions in Python library makefile... done
checking location of python library...  
$(prefix)/lib/python2.3/site-packages
checking location of python shared modules...  
$(exec_prefix)/lib/python2.3/site-packages
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking how to run the C preprocessor... gcc -E
checking whether make sets $(MAKE)... yes
checking for inline... inline
checking PostgreSQL version... 7.4
checking PostgreSQL type catalog...  
/usr/local/pgsql/include/catalog/pg_type.h
checking for mxDateTime.h... yes
checking for main in -lcrypt... no
checking for main in -lcrypto... yes
checking for PQconnectStart in -lpq... yes
checking for PQfreeNotify in -lpq... yes
checking for asprintf... yes
configure: creating ./config.status
config.status: creating Setup
config.status: creating config.h
config.status: creating Makefile.pre
config.status: executing default commands
creating Makefile

'make' then did the good stuff and I can now use postgres on my mac  
from python

hth
tone

On 1 Sep 2004, at 04:36, Jerry LeVan wrote:

> Is it possible to build the python postgresql support library
> on Mac OSX 10.3.5 with the default python install?
>

So I guess the answer is no, as you need to d/l postgres (I got mine  
from http://www.entropy.ch/software/macosx/) and the egenix packages.

> Adding "--with-python" gets an error message about libpython
> not being a shared library when attempting to build postgresql.
> (pg 7.4.5)
>
> Thanks for any pointers.
>
> Jerry
>
> _______________________________________________
> Pythonmac-SIG maillist  -  Pythonmac-SIG at python.org
> http://mail.python.org/mailman/listinfo/pythonmac-sig
>
>
-- 
Dr Tony McDonald, Asst Director, FMSC. 0191 246 4543
School of Medical Education Development
Project Manager, FDTL-4 ePortfolios http://www.eportfolios.ac.uk/