Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication Replica identity - Mailing list pgsql-admin

From Jayson Hreczuck
Subject Re: Logical replication Replica identity
Date
Msg-id CAHg7=h67zOfPo-bOQ5tdACLZgdyOV-Hvh6=Q9eoEbirfFSPKug@mail.gmail.com
Whole thread Raw
In response to Logical replication Replica identity  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: smp
Date:
Subject: REMOVE
Next
From:
Date:
Subject: RE: Data Type to store Leading Zero(0)