Re: [DOCS] Need help finding all possible parameters for wal_level - Mailing list pgsql-docs

From David G. Johnston
Subject Re: [DOCS] Need help finding all possible parameters for wal_level
Date
Msg-id CAKFQuwa7yHNmXoLk5Gp-Dc4NMinhEU5h6AZmVH_n-9OD1RUZFQ@mail.gmail.com
Whole thread Raw
In response to Re: [DOCS] Need help finding all possible parameters for wal_level  (None <espressobeanies@gmail.com>)
Responses Re: [DOCS] Need help finding all possible parameters for wal_level
List pgsql-docs
On Fri, Sep 1, 2017 at 7:46 AM, None <espressobeanies@gmail.com> wrote:
Well, so that's what doesn't make sense. Other documentation also indicates a 'hot_standby' setting and I'm looking to see if it can do 'warm_standby' as well. I was hoping for a complete list because it seems scattered right now.

​The documentation is version specific.  All of the values allowed for the specified version are listed on that page.  There is not and never was a "warm_standby" value.  The valid values for wal_level do not fully restrict how one can setup their standby configuration but rather define the minimum possible configuration (which is basically either cold or warn standby depending on whether you decide to run an independent standby server full time).  The settings at https://www.postgresql.org/docs/current/static/runtime-config-replication.html are use if you wish to convert the warm standby into a hot standby.  In either case the relevant wal_level needs to be "replica".  It was deemed unnecessary to distinguish between "archive (cold/warn) and hot_standby" in 9.6 - in terms of what information was recorded in the WAL.

David J.

pgsql-docs by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: [DOCS] Need help finding all possible parameters for wal_level
Next
From: None
Date:
Subject: Re: [DOCS] Need help finding all possible parameters for wal_level