From: | 陈天舟 <tianzhouchen(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Last archived timestamp/xid for Point-in-Time Recovery |
Date: | 2018-03-02 07:04:51 |
Message-ID: | CAMr4XPK6mDnigZUyD62z=z7fx8SQdMY9ZkybaFpyZ1ktBu2kig@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
[1] https://www.postgresql.org/docs/9.6/static/recovery-target-settings.html
Thanks
Tianzhou
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2018-03-02 07:09:16 | Re: pg_dump outputs invalid syntax for partitions with bool partkeys in pg10 |
Previous Message | Andres Freund | 2018-03-02 06:58:58 | Re: Boolean partitions syntax |