Re: PgPool II configuration with PostgreSQL 8.4

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.

______________________________________________________________________

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

> 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.

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

On Wed, May 5, 2010 at 10:17 PM, Neha Mehta <Neha(dot)Mehta(at)lntinfotech(dot)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