Postgres Pro
Downloads
Home   >   mailing lists

Thread: Changing wal_level

Changing wal_level

From
rammohan ganapavarapu
Date:
I have a master slave setup with wal_level=replica, i am trying to see if I can change the wal_level to logical without breaking the existing replication, is it possible?

Thanks,
Ram

Re: Changing wal_level

From
Laurenz Albe
Date:
On Thu, 2021-05-13 at 10:09 -0700, rammohan ganapavarapu wrote:
> I have a master slave setup with wal_level=replica, i am trying to see if I can
>  change the wal_level to logical without breaking the existing replication, is it possible?

Yes, that is possible.  All that you need to do is restart the primary server.

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

Re: Changing wal_level

From
rammohan ganapavarapu
Date:
Thank you Laurenz!

On Fri, May 14, 2021, 3:43 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Thu, 2021-05-13 at 10:09 -0700, rammohan ganapavarapu wrote:
> I have a master slave setup with wal_level=replica, i am trying to see if I can
>  change the wal_level to logical without breaking the existing replication, is it possible?

Yes, that is possible.  All that you need to do is restart the primary server.

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