Hello Haribabu,
Thank you for your answer.
There is status of the replication:
select pg_last_xlog_receive_location() "receive_location", pg_last_xlog_replay_location() "replay_location", pg_is_in_recovery() "recovery_status", pg_is_xlog_replay_paused() "replication_paused", now() - pg_last_xact_replay_timestamp() "replication_delay";
receive_location | replay_location | recovery_status | replication_paused | replication_delay
------------------+-----------------+-----------------+--------------------+-------------------
66A/8F77A330 | 66A/8F77A330 | t | f | 00:00:00.015721
(1 row)
We have several slave servers and I also have setup new fresh slave databases several times - I got the same situation each time.
I still need help with it.
Waiting for your response. Thanks.