J
J
jakewow2020-06-29 21:09:56
PostgreSQL
jakewow, 2020-06-29 21:09:56

Postgresql cluster 1C (Patroni+etcd+HAproxy)?

Good time of the day. Does anyone work with a similar configuration? I configured the conf (postgresql, patroni, etcd, haproxy), everything works fine, everything replicates perfectly (I created a database, tables, etc.), but I can’t bind 1C to this conf.

There are 3 cars:

1c server+etcd+haproxy (10.10.10.1)
postgres1 (10.10.10.2)
postgres2 (10.10.10.3)

Server 1c and balancer are on 1 machine. If you specify one of the databases in the 1s client settings (namely, by the ip address of the postgres server) - either the 1st or the 2nd, then everything works fine, 1s starts up, you can load the database into it. But this is pointless, because if the node fails, working with 1s will be impossible. But if you specify on the client that the database is located at the address of the balancer, an error will appear. Tell me, in which direction to dig?
PS: I still don't know where to look for the logs on the client
5efa2e5aa4a11432162786.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
jakewow, 2020-06-29
@jakewow

Upd: figured it out myself. It was a crooked HAproxy config

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question