Replication streaming issue

Поиск
Список
Период
Сортировка
Искать
От
Mai Peng
Тема
Replication streaming issue
Дата
Msg-id
9669E6D4-7AC7-4EB3-AB12-BBDA8E225FB9@webedia-group.com
Список
Дерево обсуждения
Replication streaming issue Mai Peng <maily.peng@webedia-group.com>
Re: Replication streaming issue Keith <keith@keithf4.com>
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
Дата:
От: Keith
Дата:
FAQ