RDS Postgres version upgrade from 12 to 16 for metabase

Get Help
1

Hi

I am currently running metabase 0.49.9 in production using ECS fargate and for the metabase's own metadata store I am using a small t4g.micro Postgres 12.18 RDS instance

The deprecation date for the PG12 db is very near on AWS too. I need to know if I can directly upgrade the RDS to a newer build. What is the current suited Postgres version supported by Metabase for its own use (not as a data source). I preferably want to upgrade to the latest 16th version. I need to know if there is anything that could break while migration to avoid prod downtime or I can directly switch the version and call it a day.

2

Do it, no problem at all with Postgres 16

3

I don't think you can do an in-place upgrade fo Postgres, any upgrade is going to involve restoring your old database to the new server.
Zero risk.

If you want to make it more interesting, PG 17 was released last week. Not tried it yet...

4

I can test on a local version for 17 but maybe not on production

Will upgrade the version directly from RDS console or use blue/green method

5

it's a masterpiece of software engineering

1 Like
6

So I hear. I watched the release video. Then realised that 90% of it was WAY over my head!
Summary seemed to be: it's faster, it uses less memory!