In a postgres logical replication setup, how do I know the hostname and db of the subscriber? I can find the publisher details from the subscriber but how do I find subscriber details from publisher? postgres=> select * from pg_subscription;…
In Postgres when logical replication is hanging on conflict you can read pending WAL entries and see which row is conflicting as well as check LSN of that transaction using pg_logical_slot_peek_changes. There is possibility to skip failing LSN but in…
I'm starting from a scenario where a PostgreSQL instance is not configured for logical replication and has a table T with X rows. Now, when I'll enable the logical replication, create a replication_slot and a publication for the table T…
We're doing a Postgres native logical replication between two databases. Now, we're getting an error trying to update from the publisher one of thousand tables that we have. When we try to update the table it returns this error: ERROR:…
Our logical replication has started to fail with a lot of these errors on the subscriber: ERROR: could not create replication slot "pg_148211637_sync_148178452_7161337762731575223": ERROR: all replication slots are in use May 2 07:43:01 psql-06 postgres[1195903]: [2] HINT: Free one or…
I am trying to publicate the cnt_title table using PostgreSQL Logical Replication. Note that I only want to share the product titles. create publication cnt_publication_for_stk for table cnt_title where (doc_type = 'PRODUCT'); What I have found is a syntax error…