Changes between Version 1 and Version 2 of Ticket #5222, comment 9
- Timestamp:
- 08/31/22 13:22:20 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #5222, comment 9
v1 v2 14 14 --and they are identical, and still fails to upgrade. 15 15 16 -- SELECT postgis_extensions_upgrade(); 16 {{{ 17 SELECT postgis_extensions_upgrade(); 18 }}} 19 17 20 18 21 NOTICE: Extension postgis_sfcgal is not available or not packagable for some reason … … 28 31 -- This file just has text "-- Nothing to do here" 29 32 33 {{{ 30 34 C:\Program Files\PostgreSQL\11\share\extension>dir postgis--unpa*.* 35 }}} 36 31 37 32 38 Directory of C:\Program Files\PostgreSQL\11\share\extension … … 41 47 -- if I want I can reinstall postgis_raster extension 42 48 43 -- SELECT postgis_full_version(); 49 50 {{{ 51 SELECT postgis_full_version(); 52 }}} 53 44 54 45 55 "POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" … … 48 58 RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)" 49 59 50 -- ALTER EXTENSION postgis UPDATE; 60 {{{ 61 ALTER EXTENSION postgis UPDATE; 62 }}} 63 51 64 52 65 Query returned successfully in 599 msec. 53 66 54 -- SELECT postgis_full_version(); 67 {{{ 68 SELECT postgis_full_version(); 69 }}} 55 70 56 71 "POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" … … 59 74 RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)" 60 75 61 -- ALTER EXTENSION postgis UPDATE; 76 {{{ 77 ALTER EXTENSION postgis UPDATE; 78 }}} 62 79 63 80 NOTICE: version "3.2.3" of extension "postgis" is already installed … … 66 83 Query returned successfully in 160 msec. 67 84 68 -- SELECT postgis_extensions_upgrade(); 85 {{{ 86 SELECT postgis_extensions_upgrade(); 87 }}} 69 88 70 89 "Upgrade completed, run SELECT postgis_full_version(); for details" … … 89 108 1 rows affected. 90 109 91 -- SELECT postgis_full_version(); 110 {{{ 111 SELECT postgis_full_version(); 112 }}} 92 113 93 114 "POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" … … 95 116 LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" RASTER" 96 117 97 -- SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%'; 118 {{{ 119 SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%'; 120 }}} 98 121 99 122 "postgis" "3.2.3" "3.2.3" "PostGIS geometry and geography spatial types and functions" 100 123 101 -- CREATE EXTENSION postgis_raster; 124 {{{ 125 CREATE EXTENSION postgis_raster; 126 }}} 102 127 103 128 ERROR: extension "postgis_raster" already exists 104 129 SQL state: 42710 105 130 106 -- DROP EXTENSION postgis_raster; 131 {{{ 132 DROP EXTENSION postgis_raster; 133 }}} 107 134 108 135 DROP EXTENSION … … 110 137 Query returned successfully in 125 msec. 111 138 112 -- SELECT postgis_full_version(); 139 {{{ 140 SELECT postgis_full_version(); 141 }}} 113 142 114 143 "POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" … … 119 148 -- Try to install postgis_raster extension 120 149 121 -- CREATE EXTENSION postgis_raster; 150 {{{ 151 CREATE EXTENSION postgis_raster; 152 }}} 122 153 123 154 CREATE EXTENSION … … 125 156 Query returned successfully in 252 msec. 126 157 127 -- SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%'; 158 {{{ 159 SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%'; 160 }}} 128 161 129 162 "postgis" "3.2.3" "3.2.3" "PostGIS geometry and geography spatial types and functions" 130 163 131 -- DROP EXTENSION postgis_raster; 164 {{{ 165 DROP EXTENSION postgis_raster; 166 }}} 132 167 133 168 DROP EXTENSION
