RE: issue with synchronized_standby_slots - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: issue with synchronized_standby_slots
Date
Msg-id OSCPR01MB1496675D9BFD519DA57A98368F5F1A@OSCPR01MB14966.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: issue with synchronized_standby_slots  (Shlok Kyal <shlok.kyal.oss@gmail.com>)
Responses Re: issue with synchronized_standby_slots
List pgsql-hackers
Dear Shlok,

```
-- Can set synchronized_standby_slots to a non-existent slot name.
ALTER SYSTEM SET synchronized_standby_slots='missing';
SELECT pg_reload_conf();

-- Reset the GUC.
ALTER SYSTEM RESET synchronized_standby_slots;
SELECT pg_reload_conf();
```

pg_reload_conf() is called twice here but I'm not sure it is really needed.
ALTER SYSTEM itself can validate parameters via parse_and_validate_value(elevel=ERROR),
and pg_reload_conf() won't affect synchronously. Also, the backend won't output
even if the parameter is invalid.

Best regards,
Hayato Kuroda
FUJITSU LIMITED


pgsql-hackers by date:

Previous
From: Andrew Kim
Date:
Subject: Re: Proposal for enabling auto-vectorization for checksum calculations
Next
From: Michael Paquier
Date:
Subject: Re: Making pg_rewind faster