Postgres RDS - quicksight connection

I am trying to setup QuickSight with my Postgres (15.3) instance in RDS. I have setup the VPC / security groups correctly, but when I try to add a new RDS data source I get the following error:

sourceErrorCode:	
GENERIC_SQL_EXCEPTION
sourceErrorMessage:	
The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.

I found this stackoverflow post: https://stackoverflow.com/questions/74503199/connecting-rds-to-quicksight-throws-generic-sql-exception

And there is another post here: https://repost.aws/questions/QUGVhPtYVGTzKXX5c8kjP2uw/quicksight-unable-to-connect-to-rds-postgres

Do I really need to downgrade my postgres instance to get quicksight to work?

Thanks, Angus