Postgres Pro
Downloads
Home   >   mailing lists

Re: Order of removing logical replication - Mailing list pgsql-admin

From Jayson Hreczuck
Subject Re: Order of removing logical replication
Date
Msg-id CAHg7=h6X+AuLv3-PrvoUDL_j_oWra8bnxY6ZTZsy6iSj3wM4VA@mail.gmail.com
Whole thread Raw
In response to Order of removing logical replication  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Tree view
That's the order but it's logical replication, and wouldn't interfere with your master even if you ran it out of order.  

I have 12 databases doing logical shipping to our subscription server and occasionally it breaks but the master is never affected.  When you restart the subs there will be some I/O due to data shipping however.

Since we are talking about logical rep: What I would LOVE is schema change support for the logical replication!  

On Fri, Apr 23, 2021, 9:23 AM Yambu <hyambu@gmail.com> wrote:
Hello

May i know in which order i have to stop logical replication without causing issues on postgres

1. drop subscription on slave
2. drop slot on master

regards

pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: Order of removing logical replication
Next
From: Jorge Silva
Date:
Subject: xPath in a database with LATIN1 encoding