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 Antwort
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
beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen