3 ms·

Postgres is great, but frankly this is where Amazon RDS shines for us. Outsourcing the pain of maintenance, upgrades, mirroring ...

• nikita2206 4y ago
  It still doesn’t do zero downtime upgrades though, does it?
• aeyes 4y ago
  Major version upgrades on RDS are even more of a pain because you can't reliably plan the downtime you'll need for them to finish. You push a button and then you pray that it doesn't take much longer than your test runs with restored snapshots... And then you still have to upgrade extensions and run analyze manually.
  • booi 4y ago
    And realistically.. they always take longer because your production database storage is fragmented from use
  • davidgerard 4y ago
    I test on dev/stg and multiply the time by four.
• raffraffraff 4y ago
  Aurora still can't do zero downtime upgrades though, which surprised me. You get closer with vanilla RDS PostgreSQL. And if you use RDS proxy or pgbouncer it's better. At a previous company I had to tend to a large here of MySQL clusters and we did all sorts of zero-downtime stuff there. I've found MySQL replication far easier to work with.