Try to migrate from POstgres 9.6.24 to 10

0

Hi,

I would like to update my current Postgres database from version 9.6.24 to 10.19. When update is done, I see precheck log file that indicates migration failure because of Postgis extension. Current POstgis extension is 2.5.5 in my 9.6.24 Postgres database. Do you have any idea how to manage this issue ? I use this extension in my database so I can't delete this extension ( because has I understand this will delete associated column in my database). Thanks in advance for your help.

Best Regards

1개 답변
0

It looks like that you might have to upgrade the Postgis extension first. This blog post should help you- https://aws.amazon.com/premiumsupport/knowledge-center/rds-postgresql-upgrade-postgis/

I strongly recommend you to test the approach on a TEST database first.

AWS
D-Rao
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠