News for hackers. Stuff that matters.
Re:Spilo: High Availability PostgreSQL cluster using Docker by bambambazooka on Wednesday June 12, 2024 @12:53PM (#40660252)
You can put HAProxy in front with a write- and a read-frontend with a backend each and all servers in the backend. To determine which server is a write instance or a standby you can provide a `external-check command` to the backends. That command can be a bash script, that connects to the server and executes `SELECT pg_is_in_recovery();`.

There are no comments on this comment yet.