search

ibm-cloud-docs / databases-for-postgresql

2 stars 12 forks source link

Steps for updating postgis not necessarily correct based on prior postgres DB version #26

Open jimlindeman opened 10 months ago

jimlindeman commented 10 months ago

The documentation at https://cloud.ibm.com/docs/databases-for-postgresql?topic=databases-for-postgresql-upgrading&interface=ui#upgrading-reqs mentions use of 

SELECT * FROM update_to_postgis_33();

but when on a ICD database version 11, that fails with "function update_to_postgis_33() does not exist". I did find, however that "upgrade_to_postgis_31()" did exist and would try to update to 3.1.7. That said, I had already upgraded using:

SELECT postgis_extensions_upgrade();

which seemed to install postgis extension to 3.3.2.

So documentation there should reflect the different methods found on postgres11 vs. postgres12 vs. postgres13 etc. I'm assuming now I can upgrade to postgres15, the update_to_postgis_33(); will be found on that server.