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

Adam
質問済み 1ヶ月前87ビュー
1回答
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
サポートエンジニア
Kyle_B
回答済み 9日前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ