Re: TODO: replica information functions

On 28-07-2015 15:35, Josh Berkus wrote:
> 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
>
+1.

> pg_standby_conninfo()
> returns connection string to master. Superuser-only for
> previously discussed reasons
>
-1. It could be retrieved using the proposal below.

> pg_recovery_config(config_item TEXT)
> returns the specified configuration item from recovery.conf
> superuser-only?
>
pg_recovery_config(OUT name text, OUT setting text) SETOF record

or

pg_recovery_config(OUT name text, OUT setting text, IN all bool) SETOF
record

This function covers pg_standby_conninfo().

--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento