Hacker News
- Zero downtime Postgres upgrades https://knock.app/blog/zero-downtime-postgres-upgrades 115 comments
- A PostgreSQL Docker container that automatically upgrades your database https://github.com/justinclift/docker-pgautoupgrade 88 comments
- Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate https://github.com/shayonj/pg_easy_replicate 62 comments
- Upgrade a 1TB PostgreSQL DB in under 10m https://www.hackenberger.at/blog/2022/07/12/how-to-postgresql-upgrades-on-large-dbs/ 3 comments
- PostgreSQL upgrades are hard https://andreas.scherbaum.la/blog/archives/1116-PostgreSQL-Upgrades-are-hard!.html#_content 120 comments
- How we upgraded our 4TB Postgres database https://retool.com/blog/how-we-upgraded-postgresql-database/ 210 comments
- Crunchy Bridge: In-place Upgrades, Postgres 14, more https://blog.crunchydata.com/blog/crunchy-bridge-in-place-upgrades-postgres-14 2 comments
- Gitlab.com PostgreSQL Database Upgrade https://status.gitlab.com/pages/maintenance/5b36dc6502d06804c08349f7/6058d9afc2f813053d93ef22 2 comments
- How we upgraded PostgreSQL https://about.gitlab.com/blog/2020/09/11/gitlab-pg-upgrade/ 6 comments
Lobsters
- Zero downtime Postgres upgrades https://knock.app/blog/zero-downtime-postgres-upgrades 14 comments databases , devops
- PostgreSQL Upgrades are hard https://andreas.scherbaum.la/blog/archives/1116-PostgreSQL-Upgrades-are-hard!.html 48 comments databases , devops
- Upgrading PostgreSQL from version 10 to 11 on Ubuntu 19.04 (Disco Dingo) https://www.paulox.net/2019/05/28/upgrading-postgresql-from-version-10-to-11-on-ubuntu-19-04-disco-dingo/ 6 comments databases , devops , linux
- Why upgrade PostgreSQL? http://why-upgrade.depesz.com/show?from=9.6&to=10.2 8 comments databases , practices
- A Comprehensive PostgreSQL Upgrade Guide! https://insanedba.blogspot.com/2024/04/howtoupgrade-postgresql.html 0 comments postgresql
- A Comprehensive PostgreSQL Upgrade Guide! https://insanedba.blogspot.com/2024/04/howtoupgrade-postgresql.html 0 comments database
- Zero downtime Postgres upgrades https://knock.app/blog/zero-downtime-postgres-upgrades 2 comments postgresql
- Zero downtime Postgres upgrades | Knock https://knock.app/blog/zero-downtime-postgres-upgrades 2 comments postgresql
- How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade https://blog.kennycoder.io/2023/08/19/How-We-Achieved-Minimal-Downtime-During-Our-PostgreSQL-Database-Upgrade-English-version/ 14 comments programming
- Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate https://github.com/shayonj/pg_easy_replicate 5 comments postgresql
- CRITICAL: PostgreSQL 14.4 Released! (A must upgrade for users of 14.x) https://www.postgresql.org/about/news/postgresql-144-released-2470/ 2 comments postgresql
- How we upgraded our 4 TB main application Postgres database https://retool.com/blog/how-we-upgraded-postgresql-database/ 5 comments programming
- How we upgraded our 4 TB main application Postgres database https://retool.com/blog/how-we-upgraded-postgresql-database/ 2 comments postgresql
- How we upgraded our 4 TB main application Postgres database https://retool.com/blog/how-we-upgraded-postgresql-database/ 8 comments postgresql
- Upgrading to PostgreSQL 14 on FreeBSD 13 (tutorial) https://henvic.dev/posts/postgres-14-freebsd-13/ 4 comments freebsd
- Issues with upgrading Heroku Postgres database tier https://devcenter.heroku.com/articles/updating-heroku-postgres-databases 10 comments heroku
- Postgres upgrade going terrible | Help https://dba.stackexchange.com/questions/30949/cannot-shutdown-old-postmaster-when-upgrading-to-postgres-9-2/54635 32 comments devops
- PostgreSQL 9 now available ... built-in replication, anonymous code blocks, in-place upgrades and more http://www.postgresql.org/about/news.1235 80 comments programming
- Amazon Aurora with PostgreSQL compatibility supports in-place upgrade from PostgreSQL 9.6 to 10 https://aws.amazon.com/about-aws/whats-new/2020/03/amazon-aurora-with-postgresql-compatibility-supports-in-place-upgrade-from-96-to-10/ 4 comments aws
- PostgreSQL Development Priorities for 8.4, 8.5 and beyond (replication, in-place upgrades, ...) http://it.toolbox.com/blogs/database-soup/postgresql-development-priorities-31886 13 comments programming
- Slow queries "select distinct" after upgrading PostgreSQL 12 + TimescaleDB to version 14 with pg_upgrade. WCGW? https://docs.timescale.com/timescaledb/latest/how-to-guides/update-timescaledb/update-timescaledb-2 6 comments postgresql
- Spatially enabled table queries much slower after upgrade from Postgres 11 to Postgres 13 https://mapserver.org/index.html 13 comments postgresql