pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPgPool II configuration with PostgreSQL 8.4
4+ messages / 4 participants
[nested] [flat]
* PgPool II configuration with PostgreSQL 8.4
@ 2010-05-06 04:17 Neha Mehta <Neha.Mehta@lntinfotech.com>
0 siblings, 3 replies; 4+ messages in thread
From: Neha Mehta @ 2010-05-06 04:17 UTC (permalink / raw)
To: pgsql-performance
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.
______________________________________________________________________
Attachments:
image001.gif (image/gif, 7.7K) download
view image
* Re: PgPool II configuration with PostgreSQL 8.4
@ 2010-05-06 06:29 Marcos Ortiz <mlortiz@uci.cu>
parent: Neha Mehta <Neha.Mehta@lntinfotech.com>
2 siblings, 0 replies; 4+ messages in thread
From: Marcos Ortiz @ 2010-05-06 06:29 UTC (permalink / raw)
To: Neha Mehta <Neha.Mehta@lntinfotech.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PgPool II configuration with PostgreSQL 8.4
@ 2010-05-06 07:09 Tatsuo Ishii <ishii@postgresql.org>
parent: Neha Mehta <Neha.Mehta@lntinfotech.com>
2 siblings, 0 replies; 4+ messages in thread
From: Tatsuo Ishii @ 2010-05-06 07:09 UTC (permalink / raw)
To: Neha.Mehta@lntinfotech.com; +Cc: pgsql-performance
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PgPool II configuration with PostgreSQL 8.4
@ 2010-05-06 22:28 Rosser Schwarz <rosser.schwarz@gmail.com>
parent: Neha Mehta <Neha.Mehta@lntinfotech.com>
2 siblings, 0 replies; 4+ messages in thread
From: Rosser Schwarz @ 2010-05-06 22:28 UTC (permalink / raw)
To: Neha Mehta <Neha.Mehta@lntinfotech.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-05-06 22:28 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-06 04:17 PgPool II configuration with PostgreSQL 8.4 Neha Mehta <Neha.Mehta@lntinfotech.com>
2010-05-06 06:29 ` Marcos Ortiz <mlortiz@uci.cu>
2010-05-06 07:09 ` Tatsuo Ishii <ishii@postgresql.org>
2010-05-06 22:28 ` Rosser Schwarz <rosser.schwarz@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox