Hackers,
Since merging recovery.conf with postgresql.conf is apparently off the
table indefinitely, we could really use some additional information
functions which work on the replica. Here's my list of what I need for
failover automation:
pg_standby_is_streaming()returns true if the standby is configured for streaming andis currently connected with the
master.returnsfalse if the connection to the master is broken,of if there is no primary_conninfo
pg_standby_conninfo()returns connection string to master. Superuser-only forpreviously discussed reasons
pg_recovery_config(config_item TEXT)returns the specified configuration item from recovery.confsuperuser-only?
Does this make sense? Is there other information we need?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com