Re: Fetching timeline during recovery

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, sfrost(at)snowman(dot)net, masao(dot)fujii(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fetching timeline during recovery
Date: 2020-01-03 15:11:38
Message-ID: 20200103161138.1d4950ca@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Mon, 23 Dec 2019 15:38:16 +0100
Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> wrote:
[...]
> My idea would be to return a row from pg_stat_get_wal_receiver() as soon as
> a wal receiver has been replicating during the uptime of the standby, no
> matter if there's one currently working or not. If no wal receiver is active,
> the "pid" field would be NULL and the "status" would reports eg. "inactive".
> All other fields would report their last known value as they are kept in
> shared memory WalRcv struct.

Please, find in attachment a patch implementing the above proposal.

Regards,

Attachment Content-Type Size
0001-v1-Always-expose-available-stats-from-wal-receiver.patch text/x-patch 3.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2020-01-03 15:22:02 Re: Greatest Common Divisor
Previous Message Tom Lane 2020-01-03 15:05:52 Re: sidewinder has one failure