I just setup my databases and got this LOG:
LOG: database system was shut down in recovery at 2015-06-01 13:31:21 EDT
LOG: entering standby mode
LOG: redo starts at 0/67000278
LOG: consistent recovery state reached at 0/67000350
LOG: record with zero length at 0/67000350
LOG: database system is ready to accept read only connections
LOG: started streaming WAL from primary at 0/67000000 on timeline 1
And it always stays like this, i never get a message like:
LOG: streaming replication successfully connected to primary
Additionally, i cannot run queries such as:
psql -c "SELECT pg_current_xlog_location()" -h192.168.0.10
...to calculate replication lag, I get the following message:
ERROR: recovery is in progress
HINT: WAL control functions cannot be executed during recovery
Can someone please tell me what is going on?