Re: TODO: replica information functions

> On 28 Jul 2015, at 21:35, Josh Berkus <josh@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