Postgres Pro
Downloads
Home   >   mailing lists

RE: Synchronizing slots from primary to standby - Mailing list pgsql-hackers

From Zhijie Hou (Fujitsu)
Subject RE: Synchronizing slots from primary to standby
Date
Msg-id OS0PR01MB571652CCD42F1D08D5BD69D494B3A@OS0PR01MB5716.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Synchronizing slots from primary to standby  (shveta malik <shveta.malik@gmail.com>)
Responses Re: Synchronizing slots from primary to standby
List pgsql-hackers
Tree view 
On Thursday, November 9, 2023 6:54 PM shveta malik <shveta.malik@gmail.com> wrote:
> 
> 
> PFA v32 patches which has below changes:

Thanks for updating the patch.

Here are few comments:

1.
Do we need to update the slot upgrade code in pg_upgrade to upgrade the slot's failover
property as well ?

2.
The check for wal_level < WAL_LEVEL_LOGICAL.

It seems the existing codes disallow slot creation if wal_level is not
sufficient, I am thinking we might need similar check in slot sync worker.
Otherwise, the synced slot could not be used after standby promotion.

Best Regards,
Hou zj

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cleaning up array_in()
Next
From: yuansong
Date:
Subject: How to solve the problem of one backend process crashing and causing other processes to restart?