Re: Function and view to retrieve WAL receiver status

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: Postgres Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Function and view to retrieve WAL receiver status
Date: 2015-12-14 06:15:35
Message-ID: CAB7nPqSF=m7mvQDGaZfn-oCvy6PAMeir=h7f5u5Zhf_k5gLLxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 14, 2015 at 3:09 PM, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> wrote:
> On Dec 13, 2015 9:56 PM, "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com>
> wrote:
>> If the node has no WAL receiver active, a tuple with NULL values is
>> returned instead.
>
> IMO, in the absence of a WAL receiver the SRF (and the view) should not
> return any rows.

The whole point is to not use a SRF in this case: there is always at
most one WAL receiver.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vladimir Sitnikov 2015-12-14 06:48:00 Re: W-TinyLfu for cache eviction
Previous Message Gurjeet Singh 2015-12-14 06:09:41 Re: Function and view to retrieve WAL receiver status