2 minutes reading time
(320 words)
How to upgrade PostgreSQL from 13 to 14
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
KEEP IN MIND: As always, backup your database before starting any upgrade procedure.
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:
root@debian10:~# pg_lsclusters
Ver Cluster Port Status OwnerData directoryLog file
13main5432 online postgres /var/lib/postgresql/13/main log/postgresql-%Y-%m-%d.log
14main5433 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
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:
postgres@debian10:~$ pg_dropcluster --stop 14 main
2. Start the upgradecluster procedure:
postgres@debian10:~$ pg_upgradecluster 13 main
3. Once the operation is completed, double-check whether it is working
4. Remove the old version:
postgres@debian10:~$ pg_dropcluster --stop 13 main
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.
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:
Recent Blog Posts
16 December 2022
09 December 2022
11 October 2021