Re: Unexpected data when subscribing to logical replication slot

2024-05-10 Thread Daniel McKenzie
ml>. 3. Retrying our enrichment queries after a brief sleep if xmin < xid. This seems to be working very well so far. Daniel McKenzie Software Developer Office: +1 403.910.5927 x 251 Mobile: +44 7712 159045 Website: www.curvedental.com *Curve Dental Confidentiality Notice* This mess

Re: Unexpected data when subscribing to logical replication slot

2024-05-09 Thread Daniel McKenzie
to process the transaction before the .NET application can react to replication slot changes. Daniel McKenzie Software Developer Office: +1 403.910.5927 x 251 Mobile: +44 7712 159045 Website: www.curvedental.com *Curve Dental Confidentiality Notice* This message is intended exclusively for the ind

Re: Unexpected data when subscribing to logical replication slot

2024-05-08 Thread Daniel McKenzie
It's running both (in docker containers) and also quite a few more docker containers running various .NET applications. Daniel McKenzie Software Developer Office: +1 403.910.5927 x 251 Mobile: +44 7712 159045 Website: www.curvedental.com *Curve Dental Confidentiality Notice* This messa

Unexpected data when subscribing to logical replication slot

2024-05-08 Thread Daniel McKenzie
oduce the issue with a r7a.medium instance but not with a r7a.large EC2 instance. - Changing the Postgres synchronous_commit parameter from "on" to "off". We cannot reproduce the issue with synchronous_commit set to "off". We need help to understand this unexpected behaviour. We are using Postgres 14.10. Thanks, Daniel McKenzie