Install libpq-dev package error

postgresql debian pg
KRH picture KRH · Jun 19, 2013 · Viewed 30.4k times · Source

I tried to install pg gem and I have had this warning:

You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.

So I tried install libpq-dev package and I have had this warning:

libpq-dev : Depends: libpq5 (= 8.4.17-0squeeze1) but 9.1.9-1~bpo60+1 is to be installed

How to fix this?

Answer

mackwerk picture mackwerk · Jun 19, 2013

This should let you install the package you need :) Just tried it myself, I am not sure you will need all the packages on the second line, try it and see :)

apt-get update
apt-get install libxslt-dev libxml2-dev libpam-dev libedit-dev
aptitude install -t squeeze-backports postgresql-server-dev-9.1

Related questions

Error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

I am trying to execute pg_dump on PostgreSQL 9.0.4 server running on Debian and I am getting the error below: ./pg_dump: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory libpq.…

Read More
PostgreSQL Query to Excel Sheet

I need to export some data from PostgreSQL to Excel (quick customer wish), and the last time Excel had serious problems opening or importing my COPYd csv files (line endings, utf-8 encoding, etc), and it took me an hour at …

Read More
How to exit from query result viewer in psql?

First query: database=# select * from table limit 1; ... | (1 row) (END) I want to make a second query but I can't. ctrl+Z exits from psql. What can I press to exit only from result viewing?

Read More