public inbox for [email protected]  

help / color / mirror / Atom feed

From: Amritanshu Joshi <[email protected]>
To: [email protected]
Subject: Fwd: Anomalous behavior between two Aurora Postgres RDS clusters
Date: Tue, 1 Jul 2025 14:48:42 -0500
Message-ID: <CA+5Usmkn60jHK2BFHh=oaOAivH7zoabtpD78ia+U1mXPQ1x81A@mail.gmail.com> (raw)
In-Reply-To: <CA+5UsmmZCFKtp8kuW8AE8WKnkdE=WYvnh3BEC5USHkk96wBxZA@mail.gmail.com>
References: <CA+5UsmmZCFKtp8kuW8AE8WKnkdE=WYvnh3BEC5USHkk96wBxZA@mail.gmail.com>

Hello,

I have a question that involves two Aurora Postgres RDS clusters.

I have two clusters. With long-running transactions, one of them is able to
create a replication slot when a record is inserted into a table while the
other does not and is blocked. It does create the replication slot when the
transaction is committed. I wanted to know if this behavior is actually an
anomaly or there is a misconfiguration with the parameters that is creating
the replication slot when it should be blocked?

Also, for the long running transactions, the transaction isolation
level is *read
committed *for both the clusters.

Thank you,
Amritanshu

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Fwd: Anomalous behavior between two Aurora Postgres RDS clusters
  In-Reply-To: <CA+5Usmkn60jHK2BFHh=oaOAivH7zoabtpD78ia+U1mXPQ1x81A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox