On Thu, Sep 26, 2013 at 8:53 AM, Scott Ribe <scott_r...@elevated-dev.com> wrote: > Assuming a master & replica set up using streaming replication, hot standby, > 9.3. > > I'd like to have a single script on both machines distinguish whether it's > running on the machine with the master or replica, and take different actions > accordingly. > > Is the way to do this to check for the presence of wal sender process vs wal > receiver process? Or is there a query that could executed against sys tables > to find current running config of the local postmaster? "SELECT pg_is_in_recovery();" can be used to make the difference between a master and a slave. -- Michael
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
