Re: wal_level - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: wal_level
Date
Msg-id e70498310ba1e3de0b5f940d8c4244cda83270ac.camel@cybertec.at
Whole thread Raw
In response to wal_level  (Yambu <hyambu@gmail.com>)
List pgsql-admin
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




pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: wal_level
Next
From: Yambu
Date:
Subject: Logical replication alternative