User Tools

Site Tools


doc:appunti:linux:sa:postgresql_upgrade_11_to_13

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
doc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2022/07/07 11:44] – [After the system upgrade] niccolodoc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2023/02/03 12:38] (current) – [Execute pg_upgradecluster] niccolo
Line 10: Line 10:
     * postgresql-13-postgis-3     * postgresql-13-postgis-3
  
-The PostgreSQL database will upgrade from version **11.16** to **13.7**, the **PostGIS library** will upgrade from version **2.5.1** to **3.1.1**.+The **PostgreSQL database** will upgrade from version **11.16** to version **13.7**, the **PostGIS library** will upgrade from version **2.5.1** to version **3.1.1**.
  
 ===== After the system upgrade ===== ===== After the system upgrade =====
Line 50: Line 50:
  
 ===== Execute pg_upgradecluster ===== ===== Execute pg_upgradecluster =====
 +
 +All the administrative tasks should be performed by the **postgres** user.
  
 Connect to the new cluster and verify that it is empty (only the system databases ''postgres'', ''template0'' and ''template1'' should exist): Connect to the new cluster and verify that it is empty (only the system databases ''postgres'', ''template0'' and ''template1'' should exist):
doc/appunti/linux/sa/postgresql_upgrade_11_to_13.1657187061.txt.gz · Last modified: 2022/07/07 11:44 by niccolo