[GENERAL] How to check streaming replication status
От | Condor |
---|---|
Тема | [GENERAL] How to check streaming replication status |
Дата | |
Msg-id | 142f748e8e9a3883a99585af496f4008@stz-bg.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] How to check streaming replication status
|
Список | pgsql-general |
Hello, I have a question about master - slave replication. My version on both servers is : PostgreSQL 9.6.4 on x86_64-slackware-linux-gnu, compiled by x86_64-slackware-linux-gcc (GCC) 7.2.0, 64-bit Here is the story: Today I create a table space and move all indexes on nvmi drives. So far so good. Master server is configured as replica and start sending replication wal files to slave server, 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 Question coming in my mind: Did my slave is up to date ? I read https://wiki.postgresql.org/wiki/Streaming_Replication and know I can check status with: $ psql -c "select pg_last_xlog_receive_location()" -h192.168.0.20 (standby host) 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 ? I know if there have some different in configurations slave does not accept connections, but in my case slave have different hardware so is normal to have differences in config files. Regards, Hristo S
В списке pgsql-general по дате отправления: