SCRAM-SHA-256-PLUS

[billglennon]

Hi,

We started using the password encryption "scram-sha-256" in our PostgreSQL database (version 13.2 ) for our database users.

Now we are not able to use pgmetrics (version 1.11.0). We get the following error message => pgmetrics: pq: unknown sasl mechanism: "SCRAM-SHA-256-PLUS".

Any ideas or suggestions to look at?

Thanks!

[mdevan]

Are you using stock PostgreSQL (from official PostgreSQL APT/YUM repos or downloaded from postgresql.org) or a vendor / cloud provider distribution?

[billglennon]

Using PostgreSQL 13.2 AWS RDS.

[mdevan]

The just-committed revision 444804f should fix this. You'll need to build pgmetrics from master to try it out:

(Install Go first if you don't have it -- https://golang.org/dl/)

git clone https://github.com/rapidloop/pgmetrics
cd pgmetrics
go build ./cmd/pgmetrics

Let us know how it goes.

[billglennon]

Hi,
Just wondering, will you be doing a new release with this fix?
Thanks again for your help and quick response on this! Very much appreciated!

[mdevan]

Yes, there should be a new release sometime during this month (October).

[billglennon]

Great! Thank you!

[mdevan]

This is now available in v1.12.

[billglennon]

Great! Thanks!