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 réponse
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
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions