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?

postgresql

roundhouse

asked on Stack Overflow Jun 5, 2018 by

2 Answers

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 on Stack Overflow Jun 6, 2018 by

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

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

answered on Stack Overflow Sep 10, 2019 by

User contributions licensed under CC BY-SA 3.0