On Wed, Sep 18, 2024 at 2:49 PM shveta malik <shveta.malik@gmail.com> wrote:
>
> > > Please find the attached v46 patch having changes for the above review
> > > comments and your test review comments and Shveta's review comments.
> > >
When the synced slot is marked as 'inactive_timeout' invalidated on
hot standby due to invalidation of publisher 's failover slot, the
former starts showing NULL' inactive_since'. Is this intentional
behaviour? I feel inactive_since should be non-NULL here too?
Thoughts?
physical standby:
postgres=# select slot_name, inactive_since, invalidation_reason,
failover, synced from pg_replication_slots;
slot_name | inactive_since |
invalidation_reason | failover | synced
-------------+----------------------------------+---------------------+----------+--------
sub2 | 2024-09-18 15:20:04.364998+05:30 | | t | t
sub3 | 2024-09-18 15:20:04.364953+05:30 | | t | t
After sync of invalidation_reason:
slot_name | inactive_since | invalidation_reason |
failover | synced
-------------+----------------------------------+---------------------+----------+--------
sub2 | | inactive_timeout | t | t
sub3 | | inactive_timeout | t | t
thanks
shveta