I have change my configuration to TCP mode as below and restart haproxy but still got the same error: global maxconn 100defaults log global mode tcp retries 2 timeout client 30m timeout connect 4s timeout server 30m timeout check 5slisten stats mode tcp bind *:8009 stats enable stats uri /listen postgres bind *:5000 option httpchk http-check expect status 200 default-server inter 3s fall 3 rise 2 on-marked-down shutdown-sessions server postgresql_10.128.0.10_5432 10.128.0.10:5432 maxconn 100 check port 8008 server postgresql_10.128.0.11_5432 10.128.0.11:5432 maxconn 100 check port 8008
Vào Th 4, 21 thg 4, 2021 vào lúc 22:42 Jarno Huuskonen < jarno.huusko...@uef.fi> đã viết: > Hei, > > On Wed, 2021-04-21 at 16:27 +0100, Andrew Smalley wrote: > > From the look of your configuration you are using HTTP Mode, for > > PostgreSQL, you will need a TCP VIP > > > > I noted this because of the HTTP check > > > > try using "mode tcp" > > > > defaults has mode tcp: > > defaults > log global > mode tcp > ... > > -Jarno > > > > > On Wed, 21 Apr 2021 at 16:25, Jarno Huuskonen <jarno.huusko...@uef.fi> > > wrote: > > > > > > Hi, > > > > > > On Wed, 2021-04-21 at 21:55 +0700, thủy bùi wrote: > > > > Dear HAproxy dev,I have install all the requirement of HAproxy into > the > > > > system alongside with patroni and etcd, but finding error while call > > > > into > > > > port 5000. > > > > The information is provided as below. > > > > Please help me find out the issue. > > > > I have running HAproxy successfully > > > > > > > > But unable to connect to my database throught port 5000 > > > > > > > > > > > > psql: error: server closed the connection unexpectedly > > > > This probably means the server terminated abnormally > > > > before or while processing the request. > > > > What is your configuration? > > > > > > > ... > > > > > > Does haproxy run when you run it from cli > > > (haproxy -d -f /path/to/yourconfig.cfg) ? > > > > > > And do you have errors in your logs ? > > > > > > > Linux postgre02 3.10.0-1160.21.1.el7.x86_64 #1 SMP Tue Mar 16 > 18:28:22 > > > > UTC > > > > 2021 x86_64 x86_64 x86_64 GNU/Linux > > > > > > Looks like you're running on CentOS/RHEL 7 ? Do you have selinux > enabled > > > (getenforce) ? You'll probably need to allow haproxy to connect to all > > > ports > > > (or allow required ports). (setsebool -P haproxy_connect_any=On might > > > help). > > > > > > (Your logs should show if connections are denied). > > > > > > -Jarno > > > > > > -- > > > Jarno Huuskonen > > -- *BUI THANH THUY* Tel: 0348672994 Email: buithuy.13...@gmail.com
