[pgpool-general: 2874] Re: pgpool on app servers - how to setup the heartbeats

Tatsuo Ishii ishii at postgresql.org
Fri May 23 23:34:01 JST 2014

> Dear Guys!
> This is just strange, that when I met a situation, like "how to setup
> pgpool without the extra IP address", the list fills up the same topic
> immediately, and without having to ask any question? :)
> Just great!! We took a try using Azure, but quit because of the
> restirictions - the lack of network transparency was one of them.
> Anyway, my current question is:
> Let's suppose
> - I setup my databas backends on several nodes, they just run the
> postgresql, at least two of them
> - I setup a pgpool node on all hosts ever need to access the database
> - configure all nodes for all the DB backends above (lets say I use pgpools
> own replication)
> - every application connects "localhost", which is the pool
> Is it guaranteed the db is consistent all the time?

Yes, if you set configurations properly.

> How should I setup the pools where I should have to tell them abount the
> pgpool cluster, like configure other-pgpool, or heartbeat-destination?

You need to setup both.

> Is there any limit for the number of the pgpool nodes?

The max number of pgpool nodes is 128.

> How much network traffic should I count with?

Most network traffic is caused by PostgreSQL frontend/backend
protocol. That means, it really depends on that how your database is

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Regards,
> Attila

More information about the pgpool-general mailing list