Logical replication stuck

From: Jayson Hreczuck <jayson(dot)hreczuck(at)studentuniverse(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Logical replication stuck
Date: 2021-11-19 16:10:21
Message-ID: CAHg7=h6UcEC5+be6Ji_ahfdpbdOYJsrB3e++DY8_ko2KagcSPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good Morning,

Any idea how to unstick this? Messages don't seem to be getting sent
anymore from the pub. I've tried the Refresh command on the sub, but no
go. Any ideas? Restarting this from scratch and resyncing would be a bear
(last resort).

[image: image.png]

Thanks!
--

*Jayson Hreczuck | Principal Database AdministratorC: +1 617.571.9861*130
Turner St, Ste 530, Waltham, MA 02453

Browse pgsql-admin by date

  From Date Subject
Next Message Daulat 2021-11-23 11:54:23 User specific log file in Postgres
Previous Message Guillaume Lelarge 2021-11-15 10:29:39 Re: Problems with upgrade from 9.6 to 10 or 11 (column pg_stat_replication.sent_location does not exist)