I've a need to update a PostGres database on a regular basis and I am trying
to figure out how exactly to setup ldirectord for this. It's currently
setup on one host but we'd like to spread it out across several using
pgcluster as well as have the ability to connect to whichever hosts are
hosting it via ldirectord direction.
My config for this is:
# PostGres Interface
request="SELECT * FROM lvs_check"
It seems that I cannot seem to find any heartbeat logging of postgres
connection attempts. I've gone up to "debug 9" in ha.cf but still am not
seeing anything about postgres attempts. The required perl modules are all
installed and I've manually used the ldirectord perl code from the heartbeat
source to successfully connect but still no luck. I've also tried both with
and without the receive string (although what entirely the receive string
should be is not entirely clear) seeing as the man pages may have a typo or
two forgetting to mention pgsql.