Re: [DOCS] Need help finding all possible parameters for wal_level

Поиск
Список
Период
Сортировка
От None
Тема Re: [DOCS] Need help finding all possible parameters for wal_level
Дата
Msg-id CAOeD1699H3zfWi-oUPX7stq1_UsWRwgx6a-o0giSf=dhiNFUpg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [DOCS] Need help finding all possible parameters for wal_level  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [DOCS] Need help finding all possible parameters for wal_level  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-docs
Hi all,

Thank you. I'm using 9.6. I found all the available options in the 'postgresql.conf' file on the server itself. The explanations are good, but I was looking for something like this:

# minimal, archive, hot_standby, or logical

I saw the 'replica' option in the documentation, but not in the conf file itself, so I dunno if it's supported.

On Fri, Sep 1, 2017 at 10:58 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [DOCS] Need help finding all possible parameters for wal_level
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [DOCS] Need help finding all possible parameters for wal_level