doc:appunti:linux:sa:postgresql_upgrade_11_to_13
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
doc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2022/07/07 09:42] – [Cleanup] niccolo | doc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2023/02/03 11: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 |
===== After the system upgrade ===== | ===== After the system upgrade ===== | ||
+ | |||
+ | Verify the that the system upgrade installed the new packages, otherwise install them manually: | ||
+ | |||
+ | < | ||
+ | apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts | ||
+ | </ | ||
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: | 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 44: | 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 '' | Connect to the new cluster and verify that it is empty (only the system databases '' |
doc/appunti/linux/sa/postgresql_upgrade_11_to_13.1657186964.txt.gz · Last modified: 2022/07/07 09:42 by niccolo