On Tue, Nov 19, 2013 at 10:01 PM, Megan <nagemnna@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
