[pgpool-general: 4652] Re: PostgreSQL + Pgpool with 1 master and 2 slaves

[JotaComm]

Hi,

Another information, I'm using streaming replication between master and
slaves.

Thank you.

Best regards.


2016-04-22 16:36 GMT-03:00 JotaComm <jota.comm at gmail.com>:

> Hello,
>
> I'm configuring a pool PostgreSQL with 1 master and 2 slaves. My
> pgpool.conf:
>
> backend_hostname0 = 'master1'
> backend_port0 = 5432
> backend_weight0 = 0
> backend_data_directory0 = '/mnt/data/'
>
> backend_hostname0 = 'slave1'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_data_directory0 = '/mnt/data/'
>
> backend_hostname0 = 'slave2'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_data_directory0 = '/mnt/data/'
>
> load_balance_mode = on
>
> My PostgreSQL logs are:
>
> /tmp/postgresql-master1-2016-04-22_153443.log
>
> /tmp/postgresql-slave1-2016-04-22_153443.log
>
> /tmp/postgresql-slave2-2016-04-22_153443.log
>
> I would like to see the write queries in
> /tmp/postgresql-master1-2016-04-22_153443.log and the SELECT queries in my
> logs: /tmp/postgresql-slave1-2016-04-22_153443.log and
> /tmp/postgresql-slave2-2016-04-22_153443.log. I'm using the psql client to
> test.
>
> Could you help me with this configuration?
>
> Thanks a lot.
>
> Best regards
>
> --
> JotaComm
> http://jotacomm.wordpress.com
>



-- 
JotaComm
http://jotacomm.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160422/7d87a80b/attachment.html>