Обсуждение: wal_level

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

wal_level

От
Yambu
Дата:
Hi

I would like to implement logical replication, but currently wal_level is set to hot_standby,  if i set it to logical will it not disturb the current replication on postgres v 10?

regards

Re: wal_level

От
Laurenz Albe
Дата:
On Wed, 2020-11-04 at 10:48 +0200, Yambu wrote:
> I would like to implement logical replication, but currently wal_level is set to hot_standby,
> if i set it to logical will it not disturb the current replication on postgres v 10?

No, that won't be a problem.
The WAL levels form an increasing sequence: anything that is logged on a lower level
will also be logged on a higher level.
So streaming (physical) replication will work fine with "wal_level = logical".

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com