While I have long moved on from PostgreSQL, I continue to follow its development. I am glad to see Citus grow from a small startup with growing pains into an important part of Microsoft.
As of today AWS RDS for PostgreSQL1 does not offer cross-region replication. Short of switching to one of the RDS offerings that do support it, there is a few options to consider.
1. Do you know what your queries will look like ? In traditional SQL you design your data model to represent your business objects. Your queries can then evolve over time and can be ad-hoc. You can even create views, materialized or otherwise, to facilitate even more […]
Having configured PostgreSQL 9.3 master/slave replication from bits and pieces of documentation on the Internet, I feel like a post is in order documenting my experience for others. Installing PostgreSQL I am not going to get into too much detail here. Installation instructions are abundant and are slightly […]