Testing postGIS update in a green instance

Question

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

Answer

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

Testing postGIS update in a green instance

Conteúdo relevante