| From: | "Euler Taveira" <euler(at)eulerto(dot)com> |
|---|---|
| To: | "Andy Fan" <zhihui(dot)fan1213(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Is it possible to change wal_level online |
| Date: | 2023-09-14 13:21:59 |
| Message-ID: | 76e9f281-a70a-4c11-b2f8-d83446aa70aa@app.fastmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2023-09-14 13:53:19 | Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression |
| Previous Message | David Rowley | 2023-09-14 12:55:36 | Re: What's the eviction algorithm of newest pg version? |