PostgreSQL

PostgreSQL badcommandorfilename • 1 year ago • 100%

Zero downtime migration options with AWS RDS

Usual story - joined a startup and their production database is a single instance RDS running 11.3. We can't upgrade or scale or even change configuration without taking the database offline. We want to move everything to an Aurora Postgres compatible cluster that can scale horizontally. What options do we have? I've used Bucardo in the past to do one-way sync, but how is it at multi-master replication? What would you use for this task?

PostgreSQL JWBananas • 1 year ago • 100%

Wanted: Moderators for /c/PostgreSQL

Are/were you a moderator at /r/PostgreSQL? Send proof, and I will hand over the keys.

PostgreSQL JWBananas • 1 year ago • 100%

Highlights from the PostgreSQL 16 Beta Release https://www.enterprisedb.com/blog/highlights-postgresql-16-beta-release

PostgreSQL JWBananas • 1 year ago • 100%

What’s new in Citus 11.3 & Postgres for multi-tenant SaaS workloads www.citusdata.com

PostgreSQL JWBananas • 1 year ago • 100%

Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics – select * from depesz; https://www.depesz.com/2023/02/27/waiting-for-postgresql-16-add-pg_stat_io-view-providing-more-detailed-io-statistics/

PostgreSQL JWBananas • 1 year ago • 100%

Should PostgreSQL Become Multi-Threaded? www.percona.com