2 minutes reading time (320 words)

How to upgrade PostgreSQL from 13 to 14

pexels-andre-furtado-1263986

In our previous PostgreSQL upgrade blog post, we have shown how to upgrade on Windows machines, and this post is valid for the newer PostgreSQL versions as well. However, this time we are focusing on Debian, as there is a little bit of difference.

...

PostgreSQL upgrade

PostgreSQL (commonly known as Postgres) is a well-known, solid as a rock database. And yes, from time to time it craves for an upgrade too. Today we will learn something about PostgreSQL Windows upgrade from version 9.6 to 12. KEEP IN MIND: As a

Remember, the procedure we are going to cover now can be reused on different versions, not just 13->14. We have tested 11->14 upgrade and it worked marvelously.
First, install the newer version of Postgres 14 and then execute the command below to confirm that you have multiple Postgres instances:

As we can see here, both versions 13 and 14 are currently installed and running. Bear in mind with this type of upgrade: you need double storage space because pg_upgradecluster command is copying data.

The upgrade procedure is the following:

     1. Drop the newer version data:

     2.  Start the upgradecluster procedure:

     3. Once the operation is completed, double-check whether it is working

     4. Remove the old version:

This pretty much illustrates a different way to upgrade the cluster. Of course, there are numerous options with upgradecluster command- from version number to folder where it will store new data. However, this is maybe a topic for another blog post. Stay tuned.

×
Stay Informed

When you subscribe to the blog, we will send you an e-mail when there are new updates on the site so you wouldn't miss them.

VyOS NetFlow and EventLog configuration
Proxmox NetFlow configuration

Related Posts

Contact

Mailing and Visiting Address:
Soneco d.o.o.
Makenzijeva 24/VI, 11000 Belgrade, Serbia
Phone: +381.11.6356319
Fax: +381.11.2455210
sales@netvizura.com | support@netvizura.com

CONNECT WITH US:

linkedin facebook facebook