[atlasdb@vm1 ~]$ psql psql (11.5) PSQL: Release 2.7.0 Connected to: AtlasDB V2.7 Enterprise Edition Release - 64-bit Production Type "help" for help. atlasdb=# select * from pg_stat_replication ; pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | backend_xmin | state | sent_lsn | write_lsn | flush_lsn | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_state ------+----------+---------+------------------+---------------+-----------------+-------------+-------------------------------+--------------+-----------+-----------+-----------+-----------+------------+-----------+-----------+------------+---------------+ ------------ 3421 | 10 | atlasdb | walreceiver | 192.168.0.202 | | 33462 | 2019-12-25 18:38:34.168977+08 | | streaming | 0/3000060 | 0/3000060 | 0/3000060 | 0/3000060 | | | | 0 | async (1 row) atlasdb=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row) atlasdb=#