Home > mailing lists

Thread: Logical replication Replica identity

Logical replication Replica identity

From

Yambu

Date:

15 April 2021, 10:08:31

For logical replication do i do this on master only or on slave as well

"alter table table_name replica identity using index index_name;"

regards

Re: Logical replication Replica identity

From

Jayson Hreczuck

Date:

15 April 2021, 15:31:08

Master, as it tells the db how to identify changes. Can also use the "full" option if you are unsure.

On Thu, Apr 15, 2021, 3:08 AM Yambu <hyambu@gmail.com> wrote:

Hi

For logical replication do i do this on master only or on slave as well

"alter table table_name replica identity using index index_name;"

regards