Last archived timestamp/xid for Point-in-Time Recovery

Поиск
Список
Период
Сортировка
От 陈天舟
Тема Last archived timestamp/xid for Point-in-Time Recovery
Дата
Msg-id CAMr4XPK6mDnigZUyD62z=z7fx8SQdMY9ZkybaFpyZ1ktBu2kig@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hi pg-hackers,

We archive the WAL to a remote storage and will perform Point-in-Time Recovery by replaying the log from that remote storage. Under heavy load, our archiving pipeline is not able to archive WAL quick enough and we would like to get more visibility on the lag.

pg_stat_archiver is great. However, it only reports the last WAL archived and the time when that WAL archived. Ideally, we would also like to get the last archived timestamp/xid corresponding to the recovery_target_time and recovery_target_xid in the recovery.conf setting [1]

Any ideas on how to achieve that?


Thanks
Tianzhou

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Boolean partitions syntax
Следующее
От: Amit Langote
Дата:
Сообщение: Re: pg_dump outputs invalid syntax for partitions with bool partkeysin pg10