Re: TODO: replica information functions

> On 28 Jul 2015, at 21:35, Josh Berkus <josh(at)agliodbs(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers