Trouble setting up psycopg2 (PostGreSQL/python database)

Question

Hey, I'm pretty new to linux (using Ubuntu 11.04) so bear with me here.

I downloaded psycopg2 2.4.1 from http://linux.softpedia.com/get/Database/Database-APIs/psycopg-6404.shtml

Then I try running...

python setup.py install

..While in the directory but then it tells me..

Error: pg_config executable not found.

Please add the directory containing pg_config to the PATH or specify the full executable path with the option:

python setup.py build_ext --pg-config /path/to/pg_config build ...

... and I don't know how to get to the path of pg_config (and I can't even find it).

Thanks for any help.

Sean · Accepted Answer · 2011-05-31 18:18:23Z

2

Here's an easy solution if you find your pg_config:

find /opt /usr -name pg_config
# Take note of path
env PATH=${PATH}:/opt/local/lib/postgresql91/bin python setup.py build

Or wherever your installation of PostgreSQL dumped off your pg_config file.

answered May 31, 2011 at 18:18

Sean

10.3k4 gold badges42 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

senderle · Accepted Answer · 2011-05-30 19:11:51Z

2

You probably don't have it installed. I did this:

me@mine:~ $ pg_config
The program 'pg_config' is currently not installed.  You can install it by typing:
sudo apt-get install libpq-dev
me@mine:~ $ sudo apt-get install libpq-dev

Seemed to work.

Is there a reason you aren't installing psychopg via apt-get though? Because this would probably be the easiest solution:

sudo apt-get install python-psycopg2

FYI, many python packages are installable via apt-get, and the only thing to remember is that they generally have a python- prefix -- as in python-nltk, python-qt4-dev, and so on.

edited May 30, 2011 at 19:11

answered May 30, 2011 at 19:02

senderle

152k36 gold badges218 silver badges244 bronze badges

Collectives™ on Stack Overflow

Trouble setting up psycopg2 (PostGreSQL/python database)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related