Is there a chance to change the wal_level from logical to replica without any impact. I know this involves a restart of services but is this possible? For example if there is a already a logical replication running with master and slave setup. The question here is can I change the wal_level now from logical to replica(streaming) with the same master and slave.
If you reduce
replica, and you have a logical replication slot (as is needed for logical replication), the server will refuse to restart.
This is because
wal_level = logical is required by logical decoding and logical replication.
If you first drop the subscription and the publication, thereby removing logical replication, the replication slot will be gone, and you can reduce
To switch from logical to physical replication, you have to re-create the standby server with