Postgres Pro
Downloads
Home   >   mailing lists

Re: Check server mode (standby / master) - Mailing list pgsql-general

From Simon Riggs
Subject Re: Check server mode (standby / master)
Date
Msg-id CA+U5nMJHWeuH8K1V+YXXBJwYnod8qN++vMtf2PMPTHTCLMETLg@mail.gmail.com
Whole thread Raw
In response to Check server mode (standby / master)  (Alexander Perepelica <perepelica.alex@gmail.com>)
List pgsql-general
Tree view 
On Tue, Aug 16, 2011 at 8:46 AM, Alexander Perepelica
<perepelica.alex@gmail.com> 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

pgsql-general by date:

Previous
From: Lauri Kajan
Date:
Subject: Re: join between a table and function.
Next
From: John DeSoi
Date:
Subject: Re: [ADMIN] Using Postgresql as application server