Replication parameters in recovery.conf

Поиск
Список
Период
Сортировка
Искать

Replication parameters in recovery.conf

От:
Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Дата:
Hello,

Reading a documentation regarding recovery.conf file I found that the
reason to store 'stand-by mode' configuration inside that file is not
clear.

IMHO, a little note in description of recovery.conf will clearify
the situation. Something like "a stand-by is submode of recover mode"
and that the file used during replication will help. Same as in
recovery.conf.sample file will be fine too.

What the community thinks about it?

-- 
Aleksandr Parfenov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company

Re: Replication parameters in recovery.conf

От:
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Дата:
On 12/1/17 06:12, Aleksandr Parfenov wrote:
> Reading a documentation regarding recovery.conf file I found that the
> reason to store 'stand-by mode' configuration inside that file is not
> clear.
> 
> IMHO, a little note in description of recovery.conf will clearify
> the situation. Something like "a stand-by is submode of recover mode"
> and that the file used during replication will help. Same as in
> recovery.conf.sample file will be fine too.
> 
> What the community thinks about it?

The reasons for this are basically all historical and we are trying to
get rid of it (by moving these settings to postgresql.conf, mostly).  So
I don't think we need to spend a lot of time rationalizing this at this
point.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Replication parameters in recovery.conf

От:
Michael Paquier <michael.paquier@gmail.com>
Дата:
On Wed, Dec 6, 2017 at 11:19 AM, Peter Eisentraut
 wrote:
> The reasons for this are basically all historical and we are trying to
> get rid of it (by moving these settings to postgresql.conf, mostly).  So
> I don't think we need to spend a lot of time rationalizing this at this
> point.

Yeah, there are as well parameters that could get removed on the way,
like hot_standby for example. Most deployments don't use it to off
these days, and in Postgres 10 this moves makes even more sense as
wal_level = replica maps to both "archive" and "hot_standby", but
means the latter.
-- 
Michael

FAQ