Re: proposal: get oldest LSN - function

From: Andres Freund <andres(at)anarazel(dot)de>
To: Kartyshov Ivan <i(dot)kartyshov(at)postgrespro(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: proposal: get oldest LSN - function
Date: 2016-02-27 00:07:41
Message-ID: 20160227000741.aoiqlnpl5qbxyxsj@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2016-02-26 18:45:14 +0300, Kartyshov Ivan wrote:
> Function pg_oldest_xlog_location gets us the oldest LSN (Log Sequence
> Number) in xlog.
>
> It is useful additional tool for DBA (we can get replicationSlotMinLSN, so
> why not in master), it can show us, if xlog replication or wal-sender is
> working properly or indicate if replication on startup can get up to date
> with master, or after long turnoff must be recovered from archive.

How does it help with any of that?

- Andres

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2016-02-27 00:29:58 Re: Relation cache invalidation on replica
Previous Message Andres Freund 2016-02-27 00:05:09 Re: Proposal: Generic WAL logical messages