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