Differences

This shows you the differences between two versions of the page.

--- doc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2022/07/07 11:18] – niccolo
+++ doc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2022/07/07 11:44] – [After the system upgrade] niccolo
@@ Line 13: / Line 13: @@
 ===== After the system upgrade =====
+Verify the that the system upgrade installed the new packages, otherwise install them manually:
+<code>
+apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts
+</code>
 Once the system is fully upgraded, you will find that your databases still run on the older **11/main cluster**. Switch to the **postgres** user and run the **pg_lsclusters** command to verify:
@@ Line 83: / Line 89: @@
 ===== Cleanup =====
-All the above operations were made using the **posgres** user, not **root**. It is time to remove the old cluster and stop the new one:
+All the above operations were made using the **posgres** user (not ''root''). It is time to remove the old cluster and stop the new one:
 <code>
@@ Line 90: / Line 96: @@
 </code>
+We stopped the new cluster because we need to start it again using the **systemd** subsystem, under the controlo of the **root** user:
+<code>
+systemctl daemon-reload
+systemctl enable postgresql@13-main
+systemctl start postgresql@13-main
+</code>