Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Based on the documentation here, I want to create a pgpool II with PostgreSQL databases. When I try to install, I encounter this error:

  configure: error: libpq is not installed or libpq is old

Searching the pgpool website, they mention to run ./configure with this command:

  --with-pgsql 

OR

   --with-pgsql-includedir

OR

   --with-pgsql-libdir 

But still I'm facing the same problem. Can anyone guide me what can I do from here?

I am running PostgreSQL 9.2 intalled from a yum package on CentOS 5.

share|improve this question
    
What operating system are you running this on? How did you install PostgreSQL? Does the pg_config program exist anywhere on your system? It should be on the PATH. –  Craig Ringer Oct 16 '12 at 8:01
    
@CraigRinger I'm running Linux centos 5.And I'm installing through PostgreSQL yum repo. Currently the postgresql version is postgresql-92.there are two pg_config in my machine. one is /usr/pgsql-9.2/bin/pg_config and the other one is /usr/src/debug/postgresql-9.2.1/src/bin/pg_config –  user119720 Oct 16 '12 at 8:10
add comment

1 Answer

up vote 2 down vote accepted

Instead of compiling PgPool, why not just install it from package management?

yum install postgresql-pgpool-II

I don't use CentOS, but that's it's package name in Fedora 17, and the two are usually consistent.

Since you're using a PostgreSQL 9.2 installed via Yum on CentOS 5, you're obviously using a 3rd party packaging of PostgreSQL, so you're likely to be using the yum.postgresql.org repository. This repository claims to contain PgPool-II, so try:

yum search pgpool

and see if you find any packages. Get details on them with:

yum info packagename

Otherwise, for compiling PgPool you need the development package for PostgreSQL installed:

yum install postgresql-devel

If that alone doesn't do the trick, try making sure pg_config is on the PATH:

export PATH=$PATH:/usr/pgsql-9.2/bin
./configure

You shouldn't need to specify a libdir or includedir explicitly, as the're in /usr/include and /usr/lib (or /usr/lib64) on CentOS and those are default search locations for configure and gcc. It's most likely that you just don't have the development headers installed.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.