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 revisionLast revisionBoth sides next revision | ||
doc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2022/07/07 09:18] – niccolo | doc:appunti:linux:sa:postgresql_upgrade_11_to_13 [2022/07/07 09:45] – [PostgreSQL/PostGIS Upgrade from 11 to 13] 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 83: | Line 89: | ||
===== Cleanup ===== | ===== 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 '' |
< | < | ||
Line 90: | Line 96: | ||
</ | </ | ||
+ | We stopped the new cluster because we need to start it again using the **systemd** subsystem, under the controlo of the **root** user: | ||
+ | |||
+ | < | ||
+ | systemctl daemon-reload | ||
+ | systemctl enable postgresql@13-main | ||
+ | systemctl start postgresql@13-main | ||
+ | </ |
doc/appunti/linux/sa/postgresql_upgrade_11_to_13.txt · Last modified: 2023/02/03 11:38 by niccolo