PostgreSQL v13.0 connection problem

[YTarikKalyoncu]

Aqueduct can't connect database when PostgreSQL version is 13.0

os: windows 10 aqueduct version: 4.0.0-b1

>> aqueduct db upgrade
-- Aqueduct CLI Version: 4.0.0-b1
-- Aqueduct project version: 4.0.0-b1
*** There was an error connecting to the database 'username:pasword@localhost:5432/dbname'. 
Reason: unable to connect to database.

[roti]

The cause is "unsupported authentication method", which occurs because the postgres driver uses the md5 method, which in PostgreSQL 13 is not enabled by default (or not supported at all, I am not sure). So you either reconfigure the database (if it's possible), or downgrade PostgreSQL to v12. Or you can try to upgrade the postgres driver, but I couldn't make it work.

[PracticalCode]

Adding/modding:

• host all all 127.0.0.1/32 md5

... to:

• C:\Program Files\PostgreSQL\13\data\pg_hba.conf

... should allow md5 authentication for PostgreSQL 13. However, when I did that, I still had the same issue as @YTarikKalyoncu