Re: Acceso a postgresql desde python

O,
1. no tenes instalado el postgres
2. la instalación del pgsql no te tomo el path, por lo que cuando
busca el comando pg_config no lo encuentra. Fijate en el configure si
te da la opcion de especificar la ruta en donde estan los binarios de
pgsql.

2008/11/2 Luis Esteban de Dios Núñez <esteban(at)princesa(dot)pri(dot)sld(dot)cu>:
> Hola,
>
> Estoy tratando de instalar el software psycopg2-2.0.8 para acceder a
> postgresql desde python y obtengo el siguiente error. Vi que en el
> setup.cfg existe una linea con pg_config pero no se qu'e poner ahi.
>
> jerusalen:/media/M1GB-II/PostgreSQL/Nuevo/psycopg2-2.0.8/psycopg2-2.0.8 #
> python setup.py build
> running build
> running build_py
> running build_ext
> Warning: /bin/sh: pg_config: command not found
> building 'psycopg2._psycopg' extension
> gcc -pthread -fno-strict-aliasing -DNDEBUG -O2 -march=i586 -mtune=i686
> -fmessage-length=0 -Wall -D_FORTIFY_SOURCE=2 -g -fPIC -DPY_MAJOR_VERSION=2
> -DPY_MINOR_VERSION=4 -DHAVE_PYBOOL=1 -DHAVE_DECIMAL=1 -DHAVE_PYDATETIME=1
> -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.0.8 (dec dt ext pq3)"
> -DPSYCOPG_EXTENSIONS=1 -DPSYCOPG_NEW_BOOLEAN=1 -DHAVE_PQFREEMEM=1
> -DHAVE_PQPROTOCOL3=1 -I/usr/include/python2.4 -I. -c
> psycopg/psycopgmodule.c -o
> build/temp.linux-i686-2.4/psycopg/psycopgmodule.o
> In file included from psycopg/psycopgmodule.c:28:
> ./psycopg/psycopg.h:27:22: error: libpq-fe.h: No such file or directory
> In file included from psycopg/psycopgmodule.c:28:
> ./psycopg/psycopg.h:146: error: syntax error before ‘PGconn’
> In file included from psycopg/psycopgmodule.c:29:
> ./psycopg/connection.h:62: error: syntax error before ‘PGconn’
> ./psycopg/connection.h:62: warning: no semicolon at end of struct or union
> ./psycopg/connection.h:79: error: syntax error before ‘}’ token
> ./psycopg/connection.h:79: warning: type defaults to ‘int’ in
> declaration of ‘connectionObject’
> ./psycopg/connection.h:79: warning: data definition has no type or storage
> class
> ./psycopg/connection.h:82: error: syntax error before ‘*’ token
> ./psycopg/connection.h:83: error: syntax error before ‘*’ token
> ./psycopg/connection.h:84: error: syntax error before ‘*’ token
> ./psycopg/connection.h:85: error: syntax error before ‘*’ token
> ./psycopg/connection.h:86: error: syntax error before ‘*’ token
> ./psycopg/connection.h:87: error: syntax error before ‘*’ token
> In file included from psycopg/psycopgmodule.c:30:
> ./psycopg/cursor.h:41: error: syntax error before ‘connectionObject’
> ./psycopg/cursor.h:41: warning: no semicolon at end of struct or union
> ./psycopg/cursor.h:43: error: syntax error before ‘:’ token
> ./psycopg/cursor.h:44: error: syntax error before ‘:’ token
> ./psycopg/cursor.h:45: error: syntax error before ‘:’ token
> ./psycopg/cursor.h:57: error: syntax error before ‘*’ token
> ./psycopg/cursor.h:57: warning: type defaults to ‘int’ in declaration
> of ‘pgres’
> ./psycopg/cursor.h:57: warning: data definition has no type or storage
> class
> ./psycopg/cursor.h:59: error: syntax error before ‘lastoid’
> ./psycopg/cursor.h:59: warning: type defaults to ‘int’ in declaration
> of ‘lastoid’
> ./psycopg/cursor.h:59: warning: data definition has no type or storage
> class
> ./psycopg/cursor.h:81: error: syntax error before ‘}’ token
> ./psycopg/cursor.h:81: warning: type defaults to ‘int’ in declaration
> of ‘cursorObject’
> ./psycopg/cursor.h:81: warning: data definition has no type or storage
> class
> ./psycopg/cursor.h:84: error: syntax error before ‘*’ token
> In file included from psycopg/psycopgmodule.c:31:
> ./psycopg/lobject.h:27:28: error: libpq/libpq-fs.h: No such file or
> directory
> In file included from psycopg/psycopgmodule.c:31:
> ./psycopg/lobject.h:41: error: syntax error before ‘connectionObject’
> ./psycopg/lobject.h:41: warning: no semicolon at end of struct or union
> ./psycopg/lobject.h:47: error: syntax error before ‘oid’
> ./psycopg/lobject.h:47: warning: type defaults to ‘int’ in declaration
> of ‘oid’
> ./psycopg/lobject.h:47: warning: data definition has no type or storage
> class
> ./psycopg/lobject.h:48: warning: type defaults to ‘int’ in declaration
> of ‘lobjectObject’
> ./psycopg/lobject.h:48: warning: data definition has no type or storage
> class
> ./psycopg/lobject.h:52: error: syntax error before ‘*’ token
> ./psycopg/lobject.h:55: error: syntax error before ‘*’ token
> ./psycopg/lobject.h:56: error: syntax error before ‘*’ token
> ./psycopg/lobject.h:58: error: syntax error before ‘*’ token
> ./psycopg/lobject.h:59: error: syntax error before ‘*’ token
> ./psycopg/lobject.h:61: error: syntax error before ‘*’ token
> ./psycopg/lobject.h:62: error: syntax error before ‘*’ token
> ./psycopg/lobject.h:63: error: syntax error before ‘*’ token
> In file included from psycopg/psycopgmodule.c:33:
> ./psycopg/microprotocols.h:55: error: syntax error before
> ‘connectionObject’
> ./psycopg/microprotocols.h:58: error: syntax error before ‘*’ token
> psycopg/psycopgmodule.c: In function ‘psyco_register_type’:
> psycopg/psycopgmodule.c:249: error: syntax error before ‘)’ token
> psycopg/psycopgmodule.c:252: error: syntax error before ‘)’ token
> error: command 'gcc' failed with exit status 1
>
> --
> Saludos
>
> Luis Esteban de Dios Núñez
> --
> Saludos,
>
> Luis Esteban de Dios Núñez
>
> ---------------------------------------
> Red Telematica de Salud - Cuba
> CNICM - Infomed
> --
> TIP 8: explain analyze es tu amigo
>

--
Emanuel Calvo Franco
Syscope Postgresql DBA
BaPUG / AOSUG Member