DalgoT4D / maintenance

maintenance scripts for our ec2 machines
0 stars 0 forks source link

Upgrade Postgres on RDS for ddp-production #32

Closed fatchat closed 2 months ago

fatchat commented 2 months ago

Postgres 15 and higher require SSL by default

We have a custom parameter group called dont-force-ssl which disables this requirement

Apply it to the RDS's to be upgraded before upgrading

fatchat commented 2 months ago

First upgrading ddp-staging

Without shutting down any clients

fatchat commented 2 months ago

Upgrading to 15.8 Set the parameter group to dont-force-ssl

image
fatchat commented 2 months ago

Took about 10 minutes

fatchat commented 2 months ago

Upgrading ddp-production RDS now

image
fatchat commented 2 months ago

ddp-production RDS ugpraded to 15.8