postgres_commands

postgresh.sh

# check master/slave status
# if f its master otherwise its slave
select pg_is_in_recovery();

#check lag status
SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::INT;

# check slave status
SELECT pg_last_xlog_receive_location();

# check activity status

 select * from pg_stat_activity ;
 
 # allow selected cidr in pg_hba
 
 postgres=# show hba_file;
               hba_file
---------------------------------------
 /etc/postgresql/9.5/slave/pg_hba.conf

postgres=# SELECT pg_reload_conf();