Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica

From: m(dot)litsarev(at)postgrespro(dot)ru
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica
Date: 2024-06-13 18:07:42
Message-ID: 4ba66566b84df983c881b996eb8831f1@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

Michael,
I have fixed the patches according to your comments.

> merge both local variables into a single bits32 store?
This is done in v3-0001-Standby-mode-requested.patch

> Then this could be used with a function that returns a
> text[] array with all the states retrieved?
Placed this in the v3-0002-Text-array-sql-wrapper.patch

> The refactoring pieces and the function pieces should be split, for
> clarity.
Sure. I also added the third patch with some tests. Perhaps it would be
usefull.

Respectfully,

Mikhail Litsarev
Postgres Professional: https://postgrespro.com

Attachment Content-Type Size
v3-0003-Test-standby-is-requested.patch text/x-diff 2.9 KB
v3-0002-Text-array-sql-wrapper.patch text/x-diff 4.0 KB
v3-0001-Standby-mode-requested.patch text/x-diff 8.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Melanie Plageman 2024-06-13 18:09:01 Re: RFC: adding pytest as a supported test framework
Previous Message Robert Haas 2024-06-13 17:51:11 Re: RFC: adding pytest as a supported test framework