Feedback-ID: i0c21471d:Fastmail
User-Agent: Cyrus-JMAP/3.9.0-alpha0-745-g95dd7bea33-fm-20230905.001-g95dd7bea
Mime-Version: 1.0
Message-Id: <76e9f281-a70a-4c11-b2f8-d83446aa70aa@app.fastmail.com>
In-Reply-To: 
 <CAKU4AWrv6zuywe1VBv6kwFmtaxyi5XYqpBkAG_B46cp4s4KoSw@mail.gmail.com>
References: 
 <CAKU4AWrv6zuywe1VBv6kwFmtaxyi5XYqpBkAG_B46cp4s4KoSw@mail.gmail.com>
Date: Thu, 14 Sep 2023 10:21:59 -0300
From: "Euler Taveira" <euler@eulerto.com>
To: "Andy Fan" <zhihui.fan1213@gmail.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Is it possible to change wal_level online
Content-Type: multipart/alternative;
 boundary=87e2fcf111e341dd9582863d2a38b90d
Archived-At: <https://www.postgresql.org/message-id/76e9f281-a70a-4c11-b2f8-d83446aa70aa%40app.fastmail.com>
Precedence: bulk

--87e2fcf111e341dd9582863d2a38b90d
Content-Type: text/plain

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


--
Euler Taveira
EDB   https://www.enterprisedb.com/

--87e2fcf111e341dd9582863d2a38b90d
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso=
Normal,p.MsoNoSpacing{margin:0}</style></head><body><div>On Thu, Sep 14,=
 2023, at 7:05 AM, Andy Fan wrote:<br></div><blockquote type=3D"cite" id=
=3D"qt" style=3D""><div dir=3D"ltr"><div>Currently it is complained that=
 wal_level changes require an instance<br></div><div>restart,&nbsp; I'm =
not familiar&nbsp;with this stuff so far and I didn't get any good<br></=
div><div>information from searching the email archive.&nbsp; So I want t=
o gather&nbsp;<br></div><div>some feedbacks from experts to&nbsp; see if=
 it is possible and if not, why<br></div><div>it would be the key blocke=
r for this.&nbsp;&nbsp;Basically&nbsp;I agree that changing&nbsp;<br></d=
iv><div>the wal_level&nbsp; online will be a good experience for users.&=
nbsp;<br></div><div><div><br></div></div></div></blockquote><div><br></d=
iv><div>This topic was already discussed. See this thread [1] that was r=
equesting to<br></div><div>change the wal_level default value. There mig=
ht be other threads but I didn't<br></div><div>try hard to find them.<br=
></div><div><br></div><div><br></div><div>[1] <a href=3D"https://www.pos=
tgresql.org/message-id/20200608213215.mgk3cctlzvfuaqm6%40alap3.anarazel.=
de">https://www.postgresql.org/message-id/20200608213215.mgk3cctlzvfuaqm=
6%40alap3.anarazel.de</a><br></div><div><br></div><div><br></div><div id=
=3D"sig112409080"><div class=3D"signature">--<br></div><div class=3D"sig=
nature">Euler Taveira<br></div><div class=3D"signature">EDB&nbsp;&nbsp; =
<a href=3D"https://www.enterprisedb.com/">https://www.enterprisedb.com/<=
/a><br></div></div><div><br></div></body></html>
--87e2fcf111e341dd9582863d2a38b90d--