On 21 Nov 2014 22:14, "Steve Pribyl" wrote:
>
> Is there a better/recommended way to determine which host in a cluster is
the master or slave besides rescue.conf or pg_stat_replication? Just
looking for the "right" way to know which host is which.
>
You may query
select pg_is_in_recovery();
Th
Steve Pribyl schrieb am 21.11.2014 um 15:13:
> Is there a better/recommended way to determine which host in a
> cluster is the master or slave besides rescue.conf or
> pg_stat_replication?
>
> Just looking for the "right" way to know which
> host is which.
What about
select pg_is_in_recovery
Hey steve ,
You can by using grep command
Ps -ewf | grep PostgreSQL
If you find sender process is running that will be master if you will see
receiver process then that will be slave
In addition to this you can also use Edb fail over manager for more status
