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 Respuesta
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
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas