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

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

Browse pgsql-hackers by date

  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