On Friday, January 20, 2023 12:47 PM shveta malik <shveta.ma...@gmail.com> wrote: > 1) > Tried different variations of altering 'min_apply_delay'. All passed except > one > below: > > postgres=# alter subscription mysubnew set (min_apply_delay = '10.9min > 1ms'); ALTER SUBSCRIPTION postgres=# alter subscription mysubnew set > (min_apply_delay = '10.9min 2s 1ms'); ALTER SUBSCRIPTION --very similar to > above but fails, postgres=# alter subscription mysubnew set > (min_apply_delay = '10.9s 1ms'); > ERROR: invalid input syntax for type interval: "10.9s 1ms" FYI, this was because the interval type couldn't accept this format. But now we changed the input format from interval to integer alinged with recovery_min_apply_delay. Thus, we don't face this issue now.
Best Regards, Takamichi Osumi