HTTP server to check postgresql server status
HTTP daemon to check postgresql server status for haproxy
This repository implements a permanent HTTP daemon to monitor postgresql database state and to decide which server in configuration is active master.
Response from tool is used by haproxy to redirect traffic to writable postgres master server, to readonly slave servers and to detect unavailable postgres servers.
Configuration path is ~/.config/pgstatus.conf. Configuration file is required if you want to monitor a postgres server that is not localhost:5432 as user postgres and not using postgres as database to check.
See example configuration file in examples directory.
See example configuration for haproxy in examples/haproxy.conf.
Running the service
There is example systemd service unit available in examples/pgstatus-daemon.service, configured by default to run as postgres user (so normally no user and password needs to be configured for default postgres).
cp examples/pgstatus-daemon.service /etc/systemd/system/ systemctl daemon-reload systemctl enable pgstatus-daemon systemctl start pgstatus-daemon
The basic idea is based on website
Instead of xinetd and shell script, this implements the check as a systemd controlled permanent daemon.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size pgstatus-1.1.3.tar.gz (3.9 kB)||File type Source||Python version None||Upload date||Hashes View|