Testing postGIS update in a green instance

0

I just jumped into the deep end on this, so please bear with me.

I'm trying to update the PostgrSQL engine on a db as safely as possible, which AWS says means I should use a blue/green deployment.
I couldn't update while creating the deployment, so I created one with the same version as my current db. I couldn't update this one either, and it appears to be due to postGIS needing an update first (3.3.3 to 3.4.0). I want to try the update on the green instance in case it breaks anything, but I can't do it since it is a read only replica.

Is my only option to update the blue instance and hope it doesn't break anything? That seems wrong, so I suspect I'm missing something.

Thanks

asked 10 months ago193 views
1 Answer
0

Hi Adam,

You would need to remove the Blue/Green deployment before updating any extensions as this would be a DDL operation and would break replication. Once Postgis is updated, you should be able to recreate the deployment and attempt the update. Just make sure all of the databases have been updated too.

https://repost.aws/knowledge-center/rds-postgresql-upgrade-postgis https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html

AWS
SUPPORT ENGINEER
answered 9 months 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