Re: Right way to restore logical replication

Thanks for reply!It makes sense now why that happened and what to do in case of emergency 09.02.2021, 10:01, "Kyotaro Horiguchi" :At Mon, 08 Feb 2021 22:42:21 +0700, Игорь Выскорко wrote in Hi, community! Unfortunately can't find answer in docs and google. Hope only for yo

Re: Right way to restore logical replication

At Mon, 08 Feb 2021 22:42:21 +0700, Игорь Выскорко wrote in > Hi, community! > Unfortunately can't find answer in docs and google. Hope only for you) > [local]:5433 postgres@postgres=# drop publication pub ; > DROP PUBLICATION > Time: 3,793 ms > > [local]:5433 postgres@postgres=# insert into tb

Right way to restore logical replication

Hi, community!Unfortunately can't find answer in docs and google. Hope only for you)Have running 2 postgres locally: :5433 - postgres 11 as master:5434 - postgres 12 as slave Creating basic setup for testing:[local]:5433 postgres@postgres=# create table tbl(id serial, d text, primary key(id));CREAT