How to install libpq-dev on Centos 5.5

Question

In order to develop one web application based on postgresql, i need to install libpq on my centos.

I can install it by "apt-get install libpq-dev" on ubuntu, but i can not install it on centos by "yum install libpq".

Who can tell me how to install it, thanks!

Banjer · Answer 1 · 2012-10-17T00:10:13.693

90

I just had to install this on my CentOS 6 server since psycopg2 required pg_config. Boo yah:

yum install postgresql-devel

Update

If you still encounter issues with pg_config, you may need to add it to your PATH, e.g.:

export PATH=$PATH:/usr/pgsql-x.x/bin

where x.x is your version, such as /usr/pgsql-9.2./bin.

edited Oct 17 '12 at 00:10

answered Nov 19 '11 at 20:22

Banjer

3,854
11
40
47

4

This worked for me (I also needed pg_config to install psycopg2) – Tom Dalling May 21 '12 at 11:33
remember, if you are trying to do a global install (sudo pip install psycopg2) to add it to the right path. Wasn't working for me, even after supplying -`-install-option` with `pip install` and then I realized I was doing sudo pip install. – matchew Oct 17 '13 at 16:14

score 59 · Accepted Answer · answered Sep 29 '11 at 14:15

59

The package is called postgresql-libs on Red Hat and derived distributions.

answered Sep 29 '11 at 14:15

Peter Eisentraut

3,575
1
23
21

1

Usefull answer.so many answer tell me install libpq-dev! – Albert.Qing Jun 18 '14 at 05:41
4

`postgresql-libs` is the shared library. However, `postgresql-devel` is the development code (equivalent to Debian's `libpg-dev`). – Brian Minton Jun 09 '20 at 22:53
As mentioned, this is not the equivalent to libpq-dev. The correct answer is postgresql-devel. – Appleoddity Jun 03 '21 at 14:51

quanta · Answer 3 · 2011-09-29T06:30:19.827

7

It is libpqxx:

Name       : libpqxx-devel
Arch       : x86_64
Version    : 2.6.9
Release    : 3.el5.rf
Size       : 1.4 M
Repo       : rpmforge
Summary    : Header files, libraries and development documentation for libpqxx.
URL        : http://pqxx.org/
License    : BSD
Description: This package contains the header files, static libraries and development
           : documentation for libpqxx. If you like to develop programs using libpqxx,
           : you will need to install libpqxx-devel.

You can install it from rpmforge or epel repo:

# yum install libpqxx-devel

edited Sep 29 '11 at 06:30

answered Sep 29 '11 at 06:12

quanta

50,327
19
152
213

3

No, that's a different package. – Peter Eisentraut Sep 29 '11 at 13:44
`xx` means `C++`. – quanta Sep 29 '11 at 14:06

How to install libpq-dev on Centos 5.5

3 Answers3