Postgres unencrypted keyword is no longer supported

Question

When executing this postgres command:

EXECUTE 'CREATE USER myuser WITH UNENCRYPTED PASSWORD ''my+password''';

I see the error:

RoundhousE encountered an error.
Npgsql.PostgresException (0x80004005): 0A000: UNENCRYPTED PASSWORD is no longer supported

Is there a workaround for this, or will the password need to be manually encrypted and supplied without the UNENCRYPTED keyword?

score 2 · Accepted Answer · answered Jun 06 '18 at 06:50

2

No. All you have to do is to omit the UNENCRYPTED.

You can supply both encrypted and unencrypted passwords that way, and PostgreSQL can tell the difference automatically.

answered Jun 06 '18 at 06:50

Laurenz Albe

Thanks for the answer. I did omit the keyword but then was still getting errors when authenticating to the database via the same connection string. Would the password remain the same when logging in, assuming I removed UNENCRYPTED, but left the password value the same? – dahui Jun 06 '18 at 08:52
Sure, you can use that very same password to log into the database. Consult the PostgreSQL log to see the reason for your authentication failure. – Laurenz Albe Jun 06 '18 at 08:55
I'll try and log in again and get back to accept this answer! thanks – dahui Jun 06 '18 at 09:00

score 1 · Answer 2 · answered Sep 10 '19 at 11:28

1

PostgreSQL 10+ no longer support user creation with UNENCRYPTED password, create it with ENCRYPTED:

CREATE USER myuser WITH ENCRYPTED PASSWORD ''my+password''

answered Sep 10 '19 at 11:28

niainaLens

Doesn't that mean `my+password` should be `e363412a12831abb90257374ec38b6d4` which is the encrypted form? – Shiplu Mokaddim Dec 02 '20 at 11:11
2

means that `my+password` is your password (you put the text you want) but psql will store it encrypted – niainaLens Dec 08 '20 at 16:40

2 Answers2