Replication streaming issue

Поиск
Список
Период
Сортировка
От Mai Peng
Тема Replication streaming issue
Дата
Msg-id 9669E6D4-7AC7-4EB3-AB12-BBDA8E225FB9@webedia-group.com
обсуждение исходный текст
Ответы Re: Replication streaming issue  (Keith <keith@keithf4.com>)
Список pgsql-admin
Hello,

I’ve got a strange issue.
Here is the error in pg log:ERROR:  requested WAL segment 000000020000A01A0000004F has already been removed.
Everything is working fine: the lag is ok.
The check queries:
SELECT  client_addr,
        state,
        write_lag,
        flush_lag,
        replay_lag
FROM    pg_stat_replication
WHERE   application_name ='walreceiver’;

SELECT COALESCE(ROUND(EXTRACT(epoch FROM now() - pg_last_xact_replay_timestamp())),0) AS seconds;

How could I monitor the problem? Why the replication streaming is still working?

Thank you in advance.
Mai






В списке pgsql-admin по дате отправления:

Предыдущее
От: "Ni Na NN Guo"
Дата:
Сообщение: Re: Re: install PostgreSQL using docker
Следующее
От: Keith
Дата:
Сообщение: Re: Replication streaming issue