1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
I talked with someone at AWS. The postgis upgrade from 12.5 to 13.3 requires TWO steps. Summary is below:
-- Sequence on PG 12.x
-- primary upgrade of postgis
SELECT postgis_extensions_upgrade();
-- Reboot instance!
-- now Some parts of postgis are not yet upgraded!
-- confirm by checking this result still has "2.5"
select probin from pg_proc where proname = 'postgis_raster_lib_version';
-- Do the upgrade again
SELECT postgis_extensions_upgrade();
-- result of this query should be "raster-3"
select probin from pg_proc where proname = 'postgis_raster_lib_version';
-- Now the to upgrade to postgres 13 worked
回答済み 3年前