Is my standby fully connected?

From: Ivann Ruiz <ivann(dot)jprog(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is my standby fully connected?
Date: 2015-06-01 17:57:14
Message-ID: CA+FHAKe=tt8tXKzWsRA3NKgJQS9nUf3kooSCHPKxMsfrVFRUrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2015-06-01 18:04:26 Re: Is my standby fully connected?
Previous Message Adrian Klaver 2015-06-01 17:41:46 Re: Python 3.2 XP64 and Numpy...