[mariocesar]

I'm having trouble getting CitusDB to work with RDS, even though I'd really like to use it with AWS. Whenever I try to research how to make it happen, I get stuck in a lot of challenges and end up concluding that it might not be possible. While I could use Azure instead, I'm hesitant because I have a lot of resources and infrastructure in AWS and it wouldn't make sense to move the database layer. The idea of having to do DBA and Ops work on my own EC2 instances is overwhelming. I would appreciate any guidance on how to use RDS with Citus on their documentation. It's concerning that Citus might be withholding information about the possibility of using RDS, given that Microsoft is its partner.

[AlexB138]

Microsoft isn't its "partner", they were entirely bought by Microsoft. The goal is to make the technology an advantage for Azure, as I understand it. It's very unlikely you'll see them offer first-party support for RDS, or CloudSQL.

[janee]

Yeah it's a bit of a shame they were bought by one of the cloud providers.

Would've been great if something like Cruncy Bridge, PgAnalyze and Citus were merged into one company so that you have managed Postgres over the 3 major providers with the best pg tech out the box.

Having your DB and apps in different providers is a stuff up, the latency and data transfer costs killed us, so Citus was a non start (we don't want to manage it ourselves in EC2).

[stevefan1999]

Checkout stackgres: https://stackgres.io/install/

They are offering Citus integration

[mariocesar]

Thank you!

[krab]

Because you can't install extensions to RDS, I think it can't be done unless AWS chooses to support it.

You can still install Postgres + Citus on EC2 or use some 3rd party service to manage it for you.

[aamederen]

You can run Citus on EC2 for now.