JS postgres - wrong username connection

Question

So im trying to connect my local postgres DB to my node.js server. But im facing the ennoying issue of wrong username.

error: password authentication failed for user "Yoav Genish"

error log:

  name: 'error',
  length: 169,
  severity: 'FATAL',
  code: '28P01',

The Yoav Genish is my win10 user name and postgres just default it as the superadmin.

I have a user with premission for the DB called me and i specified it in a .env file.

Here's the .env file:

HOST='localhost'
  USER = 'me'
  DATABASE= 'api'
  PASSWORD= 'password'
  PORT=5432 '

and here's the code:

require('dotenv').config();
const Pool= require('pg').Pool;
const ENVDATA = {
    HOST: process.env.HOST,
    USER: process.env.USER,
    DATABSE: process.env.DATABASE,
    PORT: process.env.PORT,
    PASSWORD: process.env.PASSWORD
    }
var pool = new Pool(ENVDATA);

Also i verified the the ENVDATA is indeed the data in the .env file.

again, the issue is that i want to log into the local DB with the me username, but i keep getting the above error.

thanks in advance!

Yoav Genish · Accepted Answer · 2020-05-03 21:35:11Z

2

It appears to be a syntax problem. One should use Lower Case properties when passing data to the Pool meaning

const ENVDATA = {
    host : process.env.HOST,
    user: process.env.USER,
    .
    .
    .

But i found an even "clener" solution and it's using the URI String instead:

const PGURI = `postgres://${process.env.USER}:${process.env.PASSWORD}@$
{process.env.HOST}:${process.env.PORT}/${process.env.DATABASE}`;
var pool = new Pool({
    connectionString: PGURI
});

answered May 3, 2020 at 21:35

Yoav Genish

9710 bronze badges

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

Collectives™ on Stack Overflow

JS postgres - wrong username connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related