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 Answer
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
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions