Re: Is it possible to change wal_level online

On Thu, Sep 14, 2023 at 9:22 PM Euler Taveira <euler(at)eulerto(dot)com> wrote:

> On Thu, Sep 14, 2023, at 7:05 AM, Andy Fan wrote:
>
> Currently it is complained that wal_level changes require an instance
> restart, I'm not familiar with this stuff so far and I didn't get any good
> information from searching the email archive. So I want to gather
> some feedbacks from experts to see if it is possible and if not, why
> it would be the key blocker for this. Basically I agree that changing
> the wal_level online will be a good experience for users.
>
>
> This topic was already discussed. See this thread [1] that was requesting
> to
> change the wal_level default value. There might be other threads but I
> didn't
> try hard to find them.
>
>
> [1]
> https://www.postgresql.org/message-id/20200608213215.mgk3cctlzvfuaqm6%40alap3.anarazel.de
>

Thank you Euler, this one is already the best one I ever found.

--
Best Regards
Andy Fan