Thread: postgres in streaming replication mode

On Tue, Nov 19, 2013 at 10:01 PM, Megan <nagemnna@gmail.com> wrote:
> Good day all,
>
> I'm running postgres 9.2.5 with streaming replication.  Is there a way to
> tell which database is the master other then the presence or lack of
> presence of the recovery.conf file?

You can use pg_is_in_recovery().
http://www.postgresql.org/docs/devel/static/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL

This function returns false in the master, but returns true in the standby.

Regards,

--
Fujii Masao