On Tue, Aug 16, 2011 at 8:46 AM, Alexander Perepelica <perepelica.alex@xxxxxxxxx> wrote: > How can I check which mode has a sever: master or slave (standby) after I > setup replication? You can run the query pg_is_in_recovery(), available since 9.0 http://developer.postgresql.org/pgdocs/postgres/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
