Setting password_encryption to allow md5

TimescaleDB and PostgreSQL
1

I am attempting to create a new user in my Timescale database to use the ‘md5’ password encryption.

in RDS I was able to use a custom parameter group to allow md5, but I do not see that option in Timescale.

Nevertheless, I attempted to create a user by connecting as tsadmin and running this:

set password_encryption = ‘md5’;
create user tztest WITH ENCRYPTED PASSWORD ‘mypasswd01’

When I connect with this user it shows that my password encryption is ‘scram-sha-256’ :

tsdb=> show password_encryption;
password_encryption

scram-sha-256

The backstory on this is that I need to create a user for connecting AWS Glue to the Timescale database.

I had a similar problem with a Postgresql 16 RDS database and solved it by using md5 instead of scram.

So my question is, how do I handle this in Timescale?

2

Hello @IoannisTz , just to avoid me being the middle man, we recommend contacting [email protected]. Our support team prioritizes emails over this forum. Here most of the discussions are closer to TimescaleDB & Postgresql topics than our cloud.

This looks a case that could also help other folks using Cloud, so, feel free to post your answer here to also help them later.

3

Yes, My client did submit a support request and we have this resolved.

Here was the solution:

Connect as my example user: tztest

set password_encryption to ‘md5’;
\password tztest
Enter new password for user “tztest”:
Enter it again:

Then it worked fine.

Thanks.

1 Like