2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Blog2 / Andrew's PlanetPostgreSQL3 / When to deploy or upgrade to a new major PostgreSQL release
When to deploy or upgrade to a new major PostgreSQL release
Andrew Dunstan

When to deploy or upgrade to a new major PostgreSQL release

September 25, 2020/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

With the release yesterday of PostgreSQL 13, now is perhaps a good time to talk about when and how it should be deployed. We often get questions at such times like "When should I upgrade?" and "Should I switch my new planned deployment to the new release?"

The first thing to consider is this: you shouldn’t deploy any software you haven’t tested with. So unless you have been testing your app extensively with the Beta and Release Candidate builds of the new release, you shouldn’t deploy it immediately. Many deployments have no great reason to upgrade – they perform quite well and don’t need any of the new release features. We often see successful deployments that do not upgrade for years, that only apply the bug fix releases that the PostgreSQL community regularly produces, and that are always supposed to be drop in replacements, requiring far less testing and validation than a new major release.

When a new release comes out, the first thing to do is to look at the release notes. In particular, look at the section on Migration that’s always there. See if there is anything in there that might affect you. In many cases there won’t be, but you need to check just in case there is. Then look at the features. If there is something in there you need then you should plan for a deployment. That means you should do a full round of application updates if necessary, and then integration testing. Only then should you consider upgrading.

The PostgreSQL community produces bug fix releases for all supported release series (more or less any major release less than five years old) about every three months. In many cases, if you start your planning after a major release comes out, you will not be ready to deploy until the first bug fix release for it comes out. If, like many people and organizations, you prefer not to deploy .0 releases, then you can reasonably plan for a target deployment date of, say, four months after the release. PostgreSQL has generally been a lot more stable and reliable than some other software, so I think there less reason to trust its .0 releases than in the general case.

There will be cases where you really want to deploy the new release as soon as possible. Sometimes this is because of some spiffy new feature, but more often with existing deployments it’s because there is a performance improvement or a removal of some limitation that you have found irksome. In such cases it’s reasonable to deploy as soon as you can. But on no account neglect the integration testing I mentioned. "Haste makes waste" is a good motto for software management.

If you are an eager early adopter, then as the PostgreSQL community approaches a new release, keep an eye out for Beta releases. These usually appear around the middle of the year – this year Beta 1 was available in late May. This leads up to our normal release final release date around September. You can start testing with these releases. Of course, they shouldn’t be deployed in production, but if you don’t identify any issues in testing you will be ready to deploy the final release soon after it comes out. This is also one very good way to help the community – it helps us discover bugs before the release comes out, and also helps validate the releases.

Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on LinkedIn
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Get in touch with us!

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Featured External Blogs

Tomas Vondra's Blog

Our Bloggers

  • Simon Riggs
  • Alvaro Herrera
  • Andrew Dunstan
  • Craig Ringer
  • Francesco Canovai
  • Gabriele Bartolini
  • Giulio Calacoci
  • Ian Barwick
  • Marco Nenciarini
  • Mark Wong
  • Pavan Deolasee
  • Petr Jelinek
  • Shaun Thomas
  • Tomas Vondra
  • Umair Shahid

PostgreSQL Cloud

2QLovesPG 2UDA 9.6 backup Barman BDR Business Continuity community conference database DBA development devops disaster recovery greenplum Hot Standby JSON JSONB logical replication monitoring OmniDB open source Orange performance PG12 pgbarman pglogical PG Phriday postgres Postgres-BDR postgres-xl PostgreSQL PostgreSQL 9.6 PostgreSQL10 PostgreSQL11 PostgreSQL 11 PostgreSQL 11 New Features postgresql repmgr Recovery replication security sql wal webinar webinars

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
New Features in PostgreSQL 13 [Full Webinar Video] New Features in PostgreSQL 13 Smart R2DBC Repositories for PostgreSQL Databases Smart R2DBC Repositories for PostgreSQL Databases
Scroll to top
×