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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
