Re: allowing wal_level change at run time - Mailing list pgsql-hackers

From Robert Haas
Subject Re: allowing wal_level change at run time
Date
Msg-id CA+Tgmob11z9d5RTxrTCqUaJWuZboTv93C_mEj0eHC54EDnq+PQ@mail.gmail.com
Whole thread Raw
In response to allowing wal_level change at run time  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: allowing wal_level change at run time  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Tue, Aug 18, 2015 at 7:59 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> How would we handle decreases at run time?  We can prevent >=archive ->
> minimal if archiving is running or there are physical replication slots,
> and we can prevent logical -> something less if there are logical
> replication slots, but AFAICT, we don't have a way to check whether
> anyone currently needs level hot_standby.

What do you mean by "prevent"?  If the user edits postgresql.conf and
reduces the setting, and then reloads the configuration file, they
have a right to expect that the changes got applied.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: allowing wal_level change at run time
Next
From: Greg Stark
Date:
Subject: Re: Test code is worth the space