Password authentication fails for Postgres (11) connections

[dspinellis]

• Running node ./node_modules/express-admin/app.js express-admin-examples/config/pg/ errors with password authentication failed for user "liolio".
• The password and database setup seem to be correct, because providing the same password to psql -W -h 127.0.0.1 express-admin-examples liolio succeeds.
• The authentication method used by Postgres seems to be the same in both cases, because providing a wrong password to psql causes the connection to fail with exactly the same logged information as that produced by express-admin.

liolio@express-admin-examples DETAIL:  Password does not match for user "liolio".
        Connection matched pg_hba.conf line 94: "host    all             all             127.0.0.1/32            md5"

Could the error stem from an outdated node-postgres library? Currently provided node-posgres connection examples don't seem to work with the library version distributed with express-admin. For example, the first code sample fails with TypeError: Pool is not a constructor.

[simov]

Yes, last time this module was tested was around 2015 so just by looking at the pg versions on NPM something like https://www.npmjs.com/package/pg/v/4.3.0 should work.

The documentation definitely needs an update.

[dspinellis]

Thank you for the swift reply! Sadly, running npm install pg@4.3.0 does not fix the problem.

[simov]

Hi again, recently I tested the module again, you can check out my package.json version for reference. Then I tested with these two versions of PostgreSQL.

[dspinellis]

Thank you! Note that I'm no longer trying to use this package, so I'll not be able to provide feedback.