Re: Logical replication Replica identity

From: Jayson Hreczuck <jayson(dot)hreczuck(at)studentuniverse(dot)com>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Logical replication Replica identity
Date: 2021-04-15 12:31:08
Message-ID: CAHg7=h67zOfPo-bOQ5tdACLZgdyOV-Hvh6=Q9eoEbirfFSPKug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message soumik.bhattacharjee 2021-04-15 13:47:32 RE: Data Type to store Leading Zero(0)
Previous Message smp 2021-04-15 12:13:14 REMOVE