| From: | Yambu <hyambu(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Logical replication stops updating |
| Date: | 2020-12-21 10:09:02 |
| Message-ID: | CALhHtcBF1FC-gFkBqj8wKtLzMp=XRK2k6BmhbgKMhzk0Tozn4Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Thanks Laurenz,
I got the error below, and i added the primary key on slave table1, but how
do i fix the other error " published relation does not have REPLICA
IDENTITY FULL"
logical replication target relation "public.table1" has neither REPLICA
IDENTITY index nor PRIMARY KEY and published relation does not have REPLICA
IDENTITY FULL
On Mon, Dec 21, 2020 at 11:51 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> On Mon, 2020-12-21 at 11:48 +0200, Yambu wrote:
> > My logical replication stopped updating, how do i make it start again?
>
> Read the standby log file and fix the problem you see there.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yambu | 2020-12-21 11:13:10 | Re: Logical replication stops updating |
| Previous Message | abbas alizadeh | 2020-12-21 09:51:59 | Pg_upgrade issue |