Postgres Pro
Downloads
Home   >   mailing lists

Thread: PgPool II configuration with PostgreSQL 8.4

PgPool II configuration with PostgreSQL 8.4

From
Neha Mehta
Date:

 

Hi,

 

I am trying to have synchronous master-master replication in PostgreSQL8.4 using PgPool II. I am not able to configure PgPool on the system, it gives me an error, libpq is not installed or libpq is old.

 

I have tried the command , ./configure –with-pgsql = PostgreSQL dir –with-pgsql-libdir = PostgreSQL dir/lib/

 

But still could not resolve the issue.

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks & Regards,

Neha Mehta

 

 


This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.

______________________________________________________________________
Attachment

Re: PgPool II configuration with PostgreSQL 8.4

From
Tatsuo Ishii
Date:
> I am trying to have synchronous master-master replication in PostgreSQL8.4 using PgPool II. I am not able to
configurePgPool on the system, it gives me an error, libpq is not installed or libpq is old. 
>
> I have tried the command , ./configure -with-pgsql = PostgreSQL dir -with-pgsql-libdir = PostgreSQL dir/lib/
>
> But still could not resolve the issue.

What are the exact error messages? What kind of platform are you
using? What pgpool-II version?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Re: PgPool II configuration with PostgreSQL 8.4

From
Marcos Ortiz
Date:
El 06/05/2010 6:17, Neha Mehta escribió:

 

Hi,

 

I am trying to have synchronous master-master replication in PostgreSQL8.4 using PgPool II. I am not able to configure PgPool on the system, it gives me an error, libpq is not installed or libpq is old.

 

I have tried the command , ./configure –with-pgsql = PostgreSQL dir –with-pgsql-libdir = PostgreSQL dir/lib/

 

But still could not resolve the issue.

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks & Regards,

Neha Mehta

 

 


This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.

______________________________________________________________________
PgPool-II is a master-slave system, if you want to use a Master-Master System yo can take a look to Bucardo(http://www.bucardo.org)
Which is the error?
Have you installed all dependencies of PgPool? libpq5 for example.
Which is you operating system?

We need all this information to help to find a certain solution.

Regards
Attachment

Re: PgPool II configuration with PostgreSQL 8.4

From
Rosser Schwarz
Date:
On Wed, May 5, 2010 at 10:17 PM, Neha Mehta <Neha.Mehta@lntinfotech.com> wrote:

I am trying to have synchronous master-master replication in PostgreSQL8.4 using PgPool II. I am not able to configure PgPool on the system, it gives me an error, libpq is not installed or libpq is old.

(FYI: This topic is probably more germane to the -ADMIN list, or at least -GENERAL, than it is to -PERFORM.)

Is there a particular reason you're building pgpool, rather than installing it via your distribution's package manager?  Most distributions have it available these days.  (At a minimum, any distribution that's widely-used and well-enough understood to warrant hosting something as critical as your RDBMS should have it.)

FWIW, I'm successfully using pgpool-II against a pair of 8.4 instances (in the connection pool mode, not replication, and all installed from the PGDG RPM repository).  I'm also using Bucardo (in its multi-master/swap mode) to handle the replication, as suggested by someone else down-thread.  So there's an existence proof that it *can* work.

Finally, when PostgreSQL is installed, libpq.so.N is usually put under /usr/lib(64)/, not under the postgres install directory.  Your distribution should have a postgresql-devel package available which will provide a pg_config command that can be used to pass the *actual* installed locations to a configure invocation, as in:

./configure --with-pgsql-libdir=`pg_config --libdir`...

rls

--
:wq