0

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.

0

If you reduce wal_level to 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 wal_level.

To switch from logical to physical replication, you have to re-create the standby server with pg_basebackup.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.