Sequelize and peer authentication for Postgres?

Question

My postgres database has been set up to use peer authentication and I am not sure how to tell Sequelize to use this method?

Currently we are using the following:

new Sequelize("postgres://127.0.0.1/dbname", {});

I also tried the following which did not work

new Sequelize("postgresql:///dbname?host=/var/lib/postgresql");

In both cases I get the error:

SequelizeBaseError: password authentication failed for user"

Can anyone help?

Ciro Santilli OurBigBook.com · Accepted Answer · 2021-03-19 12:49:29Z

2

A bit more exploration shows the following will do the job:

new Sequelize('mydb', undefined, undefined, {
     host: '/var/run/postgresql',
     dialect: 'postgres'
   });

The actual connection is handled by the package 'pg' and this was documented in an issue.

Note, I have tested this to work with [email protected] and [email protected].

392k120 gold badges1.3k silver badges1.1k bronze badges

answered Sep 13, 2017 at 22:16

Andre M

7,7189 gold badges65 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1