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

[Dennis Gearon]

Not sure, but I don't think you can name 'backend_hostname0' three times
and get three different servers. Perhaps some unmodified cutting and
pasting late in the day?

Perhaps u meant:

backend_hostname0
.
.
.

backend_hostname1
.
.
.

backend_hostname2
.
.
.
On Apr 22, 2016 1:16 PM, "JotaComm" <jota.comm at gmail.com> wrote:

> 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
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160422/c8b808cc/attachment.html>