<div dir="ltr">Hi,<div><br></div><div>What do you get on your pgpool log and databaservers logs ? What is the output of show pool_nodes when you connect to pgpool ?</div><div><br></div><div>Thanks</div></div><br><div class="gmail_quote"><div dir="ltr">El mar., 4 dic. 2018 a las 9:02, Christian Schwaderer (<<a href="mailto:schwaderer@ivocotec.de">schwaderer@ivocotec.de</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thanks!<br>
<br>
I've tried that. However, pgpool keeps writing my node0 as "down" to its <br>
log file - no matter what I do. However, node0 is up! I can access it <br>
from withing psql and also from my app with node-postgres driver.<br>
<br>
What can I do to find out why pgpool doesn't find my node0?<br>
<br>
On 01.12.18 03:50, Bo Peng wrote:<br>
> Hi,<br>
><br>
> I think Pgpool-II considers the primary node0 is down,<br>
> even if node0 is up.<br>
><br>
> Please remove pgpool_status file which you specified in "logdir" paramater<br>
> and restart Pgpool-II.<br>
><br>
><br>
> On Fri, 30 Nov 2018 10:58:06 +0100<br>
> Christian Schwaderer <<a href="mailto:schwaderer@ivocotec.de" target="_blank">schwaderer@ivocotec.de</a>> wrote:<br>
><br>
>> Dear all,<br>
>><br>
>> On two Ubuntu 18.04 Virtual Machines, I've setup PostgreSQL 11 on each,<br>
>> one being master, the other one hot-standy. The replication works as I<br>
>> expect.<br>
>><br>
>> Now I want to add a pgpool-layer for failover. I've installed pgpool<br>
>> 4.0.2 on the first VM and configured it with these settings:<br>
>><br>
>> |port =5437backend_hostname0 ='192.168.56.177'backend_port0<br>
>> =5432backend_weight0 =1backend_data_directory0<br>
>> ='/var/lib/pgsql/data'backend_flag0<br>
>> ='ALLOW_TO_FAILOVER'backend_hostname1 ='192.168.56.178'backend_port1<br>
>> =5432backend_weight1 =1backend_data_directory1<br>
>> ='/var/lib/pgsql/data'backend_flag1<br>
>> ='ALLOW_TO_FAILOVER'master_slave_mode =onmaster_slave_sub_mode ='stream'|<br>
>><br>
>> (Hoping these are the most important things. I think I didn't change the<br>
>> rest.)<br>
>><br>
>> Now if I connect with a Postgres-client (I've tested psql and<br>
>> node-postgres) to <a href="http://192.168.56.177:5437" rel="noreferrer" target="_blank">192.168.56.177:5437</a>, I can do |SELECT| statements, but<br>
>> no |UPDATE|/|INSERT|. I'll always get |cannot execute UPDATE/INSERT in a<br>
>> read-only transaction|.<br>
>><br>
>> Is this somehow connected to misconfigured load-balancing? I'm quite new<br>
>> to this, but as far as I understand, pgpool can be configured to<br>
>> distribute read statements among slaves, while all write statements<br>
>> should go to the master. However, this is not what I want to have. So,<br>
>> what I'm a doing wrong?<br>
>><br>
>><br>
>> Best,<br>
>><br>
>> Christian<br>
>><br>
><br>
-- <br>
Christian Schwaderer, Software-Entwickler/software developer<br>
------------------------------------------------------------<br>
ivocoTec GmbH<br>
Entwicklungsabteilung/IT department<br>
<br>
Postplatz 3<br>
D-16761 Hennigsdorf<br>
<br>
<a href="https://ivocotec.de" rel="noreferrer" target="_blank">https://ivocotec.de</a><br>
Telefon/phone +49 (0)3302 20 63 230<br>
<br>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div>