In this video we discuss a number of options for providing a highly available endpoint for a Postgresql cluster finishing with a working example of using HAProxy to detect readonly and read/write servers to provide automatic redirection of client requests after a failover takes place.

Supporting files are here: https://github.com/lukos/postgres-clu...