SHRIDHAR KHANAL: PostgreSQL Minor Version Upgrade on RHEL 9: A Step-by-Step Guide with Rollback

T2Covered by 1 source · first reported by Planet PostgreSQL at 05 Nov, 13:47 UTC

Key Takeaways A minor upgrade, such as 15.13 to 15.19, only replaces the binaries. The data directory stays as it is, so there is no pg_upgrade, dump and restore, or new cluster. The upgrade command takes seconds. The real risk is not having a tested plan for when the server doesn’t come back as…