[pgpool-general: 6119] Confused between Running Modes !

[Nitish Kumar]

Hi Team,

Kindly guide me ! I am heavily confused between Running modes of PgPool II 3.7.3.

I am having 3 PostgreSQL 10 Servers running in Streaming replication Hot Standby mode. In which 1 is master and 2 are slaves. 
The 1 master PostgreSQL 10 Server supports both read/write and 2 slave PostgreSQL 10 Servers supports only read queries.

I am setting PgPool II 3.7.3 to load balance all my queries among these 3 servers based on query type i.e read queries should be distributed between
all the 3 PostgreSQL 10 servers and write query should only go to Master PostgreSQL 10 server. I don't want PgPool to do replication ! I just want PgPool to
do smart load-balancing. 

Now for this above configuration of mine I am not able to decide PgPool II 3.7.3. Running Modes. I am confused between Master-Slave(Stream) Mode 
and Streaming Replication mode !

Since the documentation for both the modes suggests that the streaming/replication and synchronization of data will be done by PostgreSQL 10 servers.

Please elaborate any technical details of both the modes if I am missing anything. And most importantly considering my PostgreSQL 10 Servers infrastructure 
which mode should I use ???

I may missing something. Any suggestions are welcome.

Regards,
Nitish Kumar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20180608/8163a730/attachment.htm>