I am panicking slightly and need some help please, I have looked online and I am still struggling. We recently upgraded our Postgres version on RDS from 11 to 16.1 as AWS was stopping support for version 11.
Read the postgres release notes and everything seemed fine. However we have a DMS task to move data from RDS to redshift, here comes the problem... DMS does not support postgres 16.1
I looked at potentially downgrading as a last resort but RDS does not even offer this. So now I am looking to get a dump from our DB and restore that dump on a downgraded RDS instance, however when I try dump I get the following error:
pg_dump: error: aborting because of server version mismatch
pg_dump: detail: server version: 16.1; pg_dump version: 15.2 (Ubuntu 15.2-1.pgdg18.04+1).
The problem here is that AWS manage this.
Any help at all will be greatly appreciated