> On 28 Jul 2015, at 21:35, Josh Berkus <j...@agliodbs.com> wrote: > > 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 and > is currently connected with the master. > returns false if the connection to the master is broken, > of if there is no primary_conninfo >
I believe we should have some function to tell if standby is configured for streaming and another function to tell if everything is okay. > pg_standby_conninfo() > returns connection string to master. Superuser-only for > previously discussed reasons > > pg_recovery_config(config_item TEXT) > returns the specified configuration item from recovery.conf > superuser-only? > > Does this make sense? Is there other information we need? > > -- > Josh Berkus > PostgreSQL Experts Inc. > http://pgexperts.com > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
