On Fri, Nov 2, 2012 at 9:06 AM, expertalert <expertalert@xxxxxxxxx> wrote: > > From command line, is there any way to find out if the server is actually a > slave server not master ?? > > I am writing some script, so for sanity check purpose , i need to know if > the server the server i am on , its actually slave > > thanks for your help. select pg_is_in_recovery() If it's true, you're on a slave; if false, master. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general