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년 전
관련 콘텐츠
- AWS 공식업데이트됨 2년 전