From: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> |
---|---|
To: | Condor <condor(at)stz-bg(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to check streaming replication status |
Date: | 2017-08-31 08:24:52 |
Message-ID: | 1794705147.238827.1504167892037@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> From: Condor <condor(at)stz-bg(dot)com>
> To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
> Sent: Thursday, 31 August 2017, 08:36:19 GMT+1
>
> after a hour I get error message on slave server:
>
> LOG: restored log file "000000010000008B000000DC" from archive
> LOG: restored log file "000000010000008B000000DD" from archive
> cp: can get attribute '/archive/000000010000008B000000DE': No such file or directory
> LOG: started streaming WAL from primary at 8B/DD000000 on timeline 1
So it read all the log from the archive then started streaming, if there are no futrher messages you're ok.
...
> and after I did it, got:
>
> STATEMENT: SELECT pg_current_xlog_location()
> ERROR: recovery is in progress
> HINT: WAL control functions cannot be executed during recovery.
>
> My question is: How I can check the replication status when the slave
> does not accept connections ?
That's right for a server in recovery you need to call pg_last_xlog_receive_location() or pg_last_xlog_replay_location() to get the current xlog position.
From | Date | Subject | |
---|---|---|---|
Next Message | Condor | 2017-08-31 08:41:50 | Re: How to check streaming replication status |
Previous Message | Condor | 2017-08-31 07:35:56 | How to check streaming replication status |