PostgreSQL Upgrades Are Hard

• postgres-upgrader

  1 7 10.0 Shell

  Update PostgreSQL data directories

  Maybe this is useful to some of you :)

  [0] https://github.com/alexandrospanagiotidis/postgres-upgrader

• cockroach

  49 27,175 10.0 Go

  CockroachDB - the open source, cloud-native distributed SQL database.

  

  I don't know about how postgres compares to others, but if you're looking for an easy-to-manage relational DB, there are a handful of new cloud-native databases that have come out in the last few years. The ones I know of are Planetscale and Cockroach DB.

  https://planetscale.com/

  https://www.cockroachlabs.com/

• CodiumAI

  codium.ai

  sponsored

  TestGPT | Generating meaningful tests for busy devs. Get non-trivial tests (and trivial, too!) suggested right inside your IDE, so you can code smart, create more value, and stay confident when you push.

  

• kubegres

  7 1,171 0.0 Go

  Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.

  

  https://www.kubegres.io/ has worked well for me. You can use custom images, provided they follow the conventions of the official postgres image. I haven't tried a major-version upgrade yet - my impression is that it will probably be a bit painful and involve some downtime and manual ops.

  Some of the more advanced operators might better handle the upgrade problem? But in general, I've been happy with Kubegres for a ~10GB database with low traffic.

• PostgreSQL

  155 12,428 9.9 C

  Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

  

Suggest a related project