Skip site navigation (1) Skip section navigation (2)

Re: error after installing on CentOS 5.8 with source

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Alan Etkin <spametki(at)gmail(dot)com>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: error after installing on CentOS 5.8 with source
Date: 2012-07-27 15:21:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: psycopg
On Fri, Jul 27, 2012 at 3:39 PM, Alan Etkin <spametki(at)gmail(dot)com> wrote:
> Thanks to all the detailed tips you've posted for the issue I managed to do
> import psycopg2 in the CentOS 5.8 VPS:


> -Removed all pg installations in the system (luckily there were no dbs to
> backup)
> -Built/Installed last PostgreSQL dist. at standard location under /usr/local
> -Re-built/installed psycopg2 source dist. (set proper pg_config parameter in
> setup.cfg)
> -I had to do this too, because psycopg2 still complained about
> location (maybe because of not setting lib dirs in setup.cfg):

No: lib dirs in setup.cfg are unused and have been dropped recently.
Only the results from pg_config are used now.

> # cp /usr/local/<pg lib> /usr/lib

I wouldn't have expected this to be requested. But what was the source
dir exactly? Didn't you have /usr/local/lib/

> After those steps Python2.7.3 plus psycopg2 runs ok. I think the last step
> might have something to do with the fact that the python interpreter
> libraries are installed under /opt/... which I think is a distribution
> non-standard location setup

This sounds strange to me: the only problem is usually to find the
libpq. When is loaded, the python-related libs have already
been loaded.

> Note: perhaps this needs further tests for db connection or other issues

You can try running the test suite with "make check", after setting
the PSYCOPG_TESTDB_* env variables and maybe creating a scratch db.
See tests/ to check what are the vars used and their


-- Daniele

In response to


psycopg by date

Next:From: Alan EtkinDate: 2012-07-28 17:54:43
Subject: error after installing on CentOS 5.8 with source
Previous:From: Alan EtkinDate: 2012-07-27 14:39:13
Subject: error after installing on CentOS 5.8 with source

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group