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?