Fwd: Anomalous behavior between two Aurora Postgres RDS clusters

From: Amritanshu Joshi <amritanshujoshi(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Fwd: Anomalous behavior between two Aurora Postgres RDS clusters
Date: 2025-07-01 19:48:42
Message-ID: CA+5Usmkn60jHK2BFHh=oaOAivH7zoabtpD78ia+U1mXPQ1x81A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Durumdara 2025-07-02 12:21:22 PLPGSQL - store fetched records in array of record
Previous Message Maksim Gorkov 2025-07-01 15:08:45 Re: The same query_id for different queries