Fwd: Anomalous behavior between two Aurora Postgres RDS clusters - Mailing list pgsql-general

From Amritanshu Joshi
Subject Fwd: Anomalous behavior between two Aurora Postgres RDS clusters
Date
Msg-id CA+5Usmkn60jHK2BFHh=oaOAivH7zoabtpD78ia+U1mXPQ1x81A@mail.gmail.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Maksim Gorkov
Date:
Subject: Re: The same query_id for different queries
Next
From: Durumdara
Date:
Subject: PLPGSQL - store fetched records in array of record