Unable to connect to AWS Redshift using psycopg2 when using SHA256 encrypted password - failed: authentication method 13 not supported

[rnarayan-lab]

psycopg2 version: 2.9.10 (dt dec pq3 ext lo64)
psycopg2 libpq version: 170005

It works fine with an md5 password encrypt but fails as following with SHA256

Error while connecting to PostgreSQL or executing query: connection to server at "***.us-west-2.redshift.amazonaws.com" (IP), port (port) failed: authentication method 13 not supported

All documentation suggests libpq version 17 definitely supports SCRAM-SHA-256, we have tried both psycopg2-binary and psycopg2 install

what works is redshift connector for the same SHA256 encrypted password, hoping for some insights on how to make this work with psycopg2?

[dvarrazzo]

I personally don't know how AWS works and I can't debug it for free. Either someone else might help you with this or you can propose a paid for consultancy. Feel free to reach in private.

[rnarayan-lab]

Thanks for your reply, what we heard from AWS is that SHA256 used by Redshift is not compatible with postgres SCRAM-SHA, they recommended using other Redshift connectors that will work with their custom SHA256