Redshift error: authentication method 13 not supported when creating a user with sha256 hashed password

0

The redshift docs say when creating a new user, you can specify your password as cleartext, md5 hash, or sha256 hash with a salt. Two valid formats they give for sha256 are sha256|<cleartext password>, and sha256|<digest>|<salt>. I tried both formats when making a user and came up with the same error: error: authentication method 13 not supported.

I tried psql that came with postgres version 14, and psql that came with version 13, both reported the same error. I also tried connecting with Navicat, and it reported the same error.

Do we need to run SET password_encryption TO sha256 or something similar?

已提問 2 年前檢視次數 1318 次
1 個回答
1

I believe you are seeing an incompatibility with the Postgres psql support for sha256 based passwords. Can you try using the rsql command-line tool to connect?

https://docs.aws.amazon.com/redshift/latest/mgmt/rsql-query-tool.html

AWS
Don_D
已回答 1 年前
AWS
專家
已審閱 1 年前
  • Got similar error when trying to connect from glue connection to redshift with user having sha256 password in redshift? any idea why

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南