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