I'm just trying to install Psycopg2 on the client (webserver) which is connected via ethernet to the Database server. But to do so I thought I had to update the pg_config and library_dirs in the psychpg2 file: setup.cfg, otherwise I get the following if I do nothing to it:
running buildcd install/psycopg2-2.0.5.1 running build_pyall/psycopg2-2.0.5.1# ls running build_ext INSTALL MANIFEST psycopg setup.cfg ZPsycopgDA Warning: /bin/sh: line 1: pg_config: command not foundtup.py building 'psycopg2._psycopg' extension scripts tests gcc -pthread -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC -DPY_MAJOR_VERSION=2 -DPY_MINOR_VERSION=5 -DHAVE_PYBOOL=1 -DHAVE_DECIMAL=1 -DHAVE_PYDATETIME=1 -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.0.5.1 (dec dt ext pq3)" -DPSYCOPG_EXTENSIONS=1 -DPSYCOPG_DISPLAY_SIZE=1 -DPSYCOPG_NEW_BOOLEAN=1 -DHAVE_PQFREEMEM=1 -DHAVE_PQPROTOCOL3=1 -I/usr/local/include/python2.5 -I. -c psycopg/psycopgmodule.c -o build/temp.linux-i686-2.5/psycopg/psycopgmodule.o In file included from psycopg/psycopgmodule.c:28: ./psycopg/connection.h:26:22: error: libpq-fe.h: No such file or directory In file included from psycopg/psycopgmodule.c:28: ./psycopg/connection.h:55: error: expected specifier-qualifier-list before 'PGconn' In file included from psycopg/psycopgmodule.c:29: ./psycopg/cursor.h:55: error: expected specifier-qualifier-list before 'PGresult' psycopg/psycopgmodule.c: In function '_psyco_connect_fill_exc': psycopg/psycopgmodule.c:103: error: 'connectionObject' has no member named 'exc_Error' psycopg/psycopgmodule.c:105: error: 'connectionObject' has no member named 'exc_Warning' psycopg/psycopgmodule.c:107: error: 'connectionObject' has no member named 'exc_InterfaceError' psycopg/psycopgmodule.c:109: error: 'connectionObject' has no member named 'exc_DatabaseError' psycopg/psycopgmodule.c:111: error: 'connectionObject' has no member named 'exc_InternalError' psycopg/psycopgmodule.c:113: error: 'connectionObject' has no member named 'exc_ProgrammingError' psycopg/psycopgmodule.c:115: error: 'connectionObject' has no member named 'exc_IntegrityError' psycopg/psycopgmodule.c:117: error: 'connectionObject' has no member named 'exc_DataError' psycopg/psycopgmodule.c:119: error: 'connectionObject' has no member named 'exc_NotSupportedError' psycopg/psycopgmodule.c:121: error: 'connectionObject' has no member named 'exc_OperationalError' error: command 'gcc' failed with exit status 1 I'm asking what do I place into the pg_config and library_dirs in order for the installation to work on the client web server? Or what do I in general to make it work? I mentioned in my previous email, that pg_config=/usr/local/pgsql/bin/pg_config and library_dirs=/usr/local/pgsql/lib on the database, but how do I reference this in the installation of Psychpg on the client webserver? ---- Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > > On Wed, 2007-04-18 at 13:49 +1000, Mark Jarecki wrote: > > To further illustrate my question. > > > > When installing Psychopg2, if the Database server was on the same > > machine as the Web server, I would normally update the setup.cfg > > prior to running "python setup.py build", with the following: > > > > pg_config=/usr/local/pgsql/bin/pg_config > > library_dirs=/usr/local/pgsql/lib > > > > However, as I want to separate the Web server and the Database > > server, and the above file and directory are on another machine (say > > 192.168.344.222), what should I enter in these fields? > > I don't really understand what you're trying to do with setup.cfg (what > package is this setup file for?), but to answer your original question, > the psycopg module lives on the database client side -- so on the web > server in this case. It is loaded and used by the webserver code to act > as a client to talk to a remote database server. Basically psycopg2 is > the python equivalent of the psql program. > > Regards, > Malcolm > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
