Thread: [PATCH] TAP test showing that pg_replication_slot_advance() works on standby
[PATCH] TAP test showing that pg_replication_slot_advance() works on standby
From
Craig Ringer
Date:
Hi all
The attached patch adds a test to the TAP logical decoding suite to show that pg_replication_slot_advance() works on a server in standby mode.
I didn't add a full demonstration of how to do failover with logical slots because we're still missing a way to "sync" a logical slot from a primary to a standby, or a way to directly create such a slot safely on a standby in a way that enforces a safe catalog_xmin etc.
You can't replay from the slot unless the server is promoted, so I don't test that.
I'm not sure if anyone's going to find it worth committing, but it's here so searchers can find it at least.
Attachment
Re: [PATCH] TAP test showing that pg_replication_slot_advance() works on standby
From
Masahiko Sawada
Date:
Hi Craig, On Tue, Nov 10, 2020 at 2:32 PM Craig Ringer <craig.ringer@enterprisedb.com> wrote: > > Hi all > > The attached patch adds a test to the TAP logical decoding suite to show that pg_replication_slot_advance() works on aserver in standby mode. > > I didn't add a full demonstration of how to do failover with logical slots because we're still missing a way to "sync"a logical slot from a primary to a standby, or a way to directly create such a slot safely on a standby in a way thatenforces a safe catalog_xmin etc. > > You can't replay from the slot unless the server is promoted, so I don't test that. > > I'm not sure if anyone's going to find it worth committing, but it's here so searchers can find it at least. You sent in your patch, 0001-Extend-TAP-test-for-pg_replication_slot_advance-to-c_patch.txt to pgsql-hackers on Nov10, but you did not post it to the next CommitFest[1]. If this was intentional, then you need to take no action. However, if you want your patch to be reviewed as part of the upcoming CommitFest, then you need to add it yourself before 2021-01-01 AOE[2]. Thanks for your contributions. Regards, [1] https://commitfest.postgresql.org/31/ [2] https://en.wikipedia.org/wiki/Anywhere_on_Earth -- Masahiko Sawada EnterpriseDB: https://www.enterprisedb.com/