News for hackers. Stuff that matters.
Re:AWS open-sourced Postgres active-active replication exten... by everfrustrated on Wednesday July 16, 2025 @10:22AM (#44582706)
I'm scratching my head trying to think why AWS would have worked on this? I can't think of it being used in any of their products.

RDS uses block replication. Aurora uses it's own SAN replication layer.

DMS maybe?

Re:AWS open-sourced Postgres active-active replication exten... by gotimo on Wednesday July 16, 2025 @10:26AM (#44582741)
probably [Aurora DSQL](https://aws.amazon.com/rds/aurora/dsql/) which released a couple of weeks ago
Re:AWS open-sourced Postgres active-active replication exten... by loginatnine on Wednesday July 16, 2025 @11:22AM (#44583287)
It's definitely DSQL with the multi-region active active feature[1].

[1]https://aws.amazon.com/rds/aurora/dsql/features/#topic-1

Re:AWS open-sourced Postgres active-active replication exten... by riknos314 on Wednesday July 16, 2025 @01:54PM (#44585084)
DSQL only uses Postgres for the query processor layer, so it doesn't require a replication library within postgres itself. Definitely NOT from DSQL.

> We’re not using any of the storage or transaction processing parts of PostgreSQL, but are using the SQL engine, an adapted version of the planner and optimizer, and the client protocol implementation. [1]

Rather, DSQL seems to do its region replication using the distributed journal abstraction [2].

[1] https://brooker.co.za/blog/2024/12/04/inside-dsql.html [2] https://brooker.co.za/blog/2024/12/06/inside-dsql-cap.html

Re:AWS open-sourced Postgres active-active replication exten... by fizx on Wednesday July 16, 2025 @10:27AM (#44582753)
I thought dsql was distributed transactions. :thinking:
Re:AWS open-sourced Postgres active-active replication exten... by mjb on Wednesday July 16, 2025 @01:18PM (#44584709)
DSQL does use distributed transactions to offer active-active alongside strong consistency and isolation guarantees. Here's how: https://brooker.co.za/blog/2024/12/05/inside-dsql-writes.htm...
Re:AWS open-sourced Postgres active-active replication exten... by tneely on Wednesday July 16, 2025 @12:21PM (#44584059)
DSQL uses an internal service, Journal[1], for its mutli-region writes.

[1]: https://www.allthingsdistributed.com/2025/05/just-make-it-sc...

Re:AWS open-sourced Postgres active-active replication exten... by thayne on Wednesday July 16, 2025 @11:45AM (#44583572)
> Aurora uses it's own SAN replication layer

I don't think that is used for cross region replication

Re:AWS open-sourced Postgres active-active replication exten... by the_precipitate on Wednesday July 16, 2025 @10:29AM (#44582763)
Yeah, and this doesn't seems to be that useful. At least I don't understand why one should do this on a strong ACID relational database.
Re:AWS open-sourced Postgres active-active replication exten... by hobs on Wednesday July 16, 2025 @10:32AM (#44582802)
In my experience multi-writer is because of latency or HADR stuff - have all your data in all regions at the same time, but the method (via the tlog) seems like it sort of defeats what those sorts of systems might be able to historically do (write multiple places from the app at the same time so as to have the lowest possible chance of data loss.)
Re:AWS open-sourced Postgres active-active replication exten... by shermantanktop on Wednesday July 16, 2025 @10:55AM (#44583009)
Yes, I call it spoke-and-hub. The sharded spokes accept the writes and replicate back to the hub, where all shards coexist.

Useful for metric ingestion. Not useful for bank ledgers or whatever.

Re:AWS open-sourced Postgres active-active replication exten... by hobs on Wednesday July 16, 2025 @11:05AM (#44583124)
Yeah, some instances also have all the shards maintain all the state and just accept writes in your partition of values, merge replication in sql server works like this.
Re:AWS open-sourced Postgres active-active replication exten... by ForHackernews on Wednesday July 16, 2025 @10:30AM (#44582775)
Apparently they've offered it as a feature in RDS Postgres for a couple years now https://aws.amazon.com/about-aws/whats-new/2023/10/pgactive-...

But only last month did they officially release it as open source to the community https://aws-news.com/article/2025-06-09-announcing-open-sour...

Re:AWS open-sourced Postgres active-active replication exten... by everfrustrated on Wednesday July 16, 2025 @12:51PM (#44584408)
Thanks, that seems to match.
Re:AWS open-sourced Postgres active-active replication exten... by 0xFF0123 on Wednesday July 16, 2025 @12:54PM (#44584431)
A lot of theorising above, but this seems like the earliest reference
Re:AWS open-sourced Postgres active-active replication exten... by cfycom on Wednesday July 16, 2025 @03:48PM (#44586095)
From the readme of the repo: "Use cases for this include running a Multi-Region high availability database cluster"
Re:AWS open-sourced Postgres active-active replication exten... by prdpx7 on Wednesday July 16, 2025 @04:34PM (#44586535)
i think AWS is using pgactive to sell "Aurora Postgres Global" https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...