pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Changing wal_level
3+ messages / 2 participants
[nested] [flat]

* Changing wal_level
@ 2021-05-13 17:09  rammohan ganapavarapu <rammohanganap@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: rammohan ganapavarapu @ 2021-05-13 17:09 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Changing wal_level
@ 2021-05-14 10:43  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: rammohan ganapavarapu <rammohanganap@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Laurenz Albe @ 2021-05-14 10:43 UTC (permalink / raw)
  To: rammohan ganapavarapu <rammohanganap@gmail.com>; pgsql-admin

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Changing wal_level
@ 2021-05-14 14:11  rammohan ganapavarapu <rammohanganap@gmail.com>
  parent: Laurenz Albe <laurenz.albe@cybertec.at>
  0 siblings, 0 replies; 3+ messages in thread

From: rammohan ganapavarapu @ 2021-05-14 14:11 UTC (permalink / raw)
  To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin

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
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2021-05-14 14:11 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-13 17:09 Changing wal_level rammohan ganapavarapu <rammohanganap@gmail.com>
2021-05-14 10:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-05-14 14:11   ` rammohan ganapavarapu <rammohanganap@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox