Re: Is my standby fully connected?

Hi,

2015-06-01 19:57 GMT+02:00 Ivann Ruiz <ivann(dot)jprog(at)gmail(dot)com>:

> 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
>
>
Sounds good to me.

> 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?
>

This is just what it's supposed to be. And it tells you exactly that. You
cannot use pg_current_xlog_location() on a slave.

Check pg_stat_replication view on the master.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com