Home > mailing lists

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

From	raghu ram
Subject	Re: Check server mode (standby / master)
Date	August 16, 2011 07:57:05
Msg-id	CALnrrJRm92sdOAGF4qBg0SED739ByLsVmGWPCFVJwrfNNAs+Bw@mail.gmail.com Whole thread Raw
In response to	Check server mode (standby / master) (Alexander Perepelica <perepelica.alex@gmail.com>)
List	pgsql-general

On Tue, Aug 16, 2011 at 1:16 PM, Alexander Perepelica <perepelica.alex@gmail.com> wrote:

Hello!

How can I check which mode has a sever: master or slave (standby) after I setup replication?

You can check the mode of the server using "pg_controldata".

[pgsql@test~]$ pg_controldata /usr/local/pgsql/data84/

Database cluster state: in archive recovery --> This is Standby Database

Database cluster state: in production --> This is Production Database [Master]

--Raghu Ram

From: Alexander Perepelica
Date: 16 August 2011, 07:46:51
Subject: Check server mode (standby / master)

From: Torsten Zühlsdorff
Date: 16 August 2011, 08:56:11
Subject: Re: PostgreSQL 'hosting'