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,
Suporte24x7 e Treinamento