Authentication error in connecting with postgres database

Question

so I am working on the backend of my web app. I keep getting this error: password authentication failed for user "postgre"

const express = require("express")
const router = express.Router()
const Pool = require('pg').Pool
const pool = new Pool({
    user: 'postgre',
    host: 'localhost',
    database: 'p2p',
    password: 'hello',
    port: 5432,
  })

router.get('/',(req,res)=>{
    res.render('physician/login')
})

//table: doc_reg, 
router.post('/loggedin',(req,res)=>{
    const {user_name,pw_1}=req.body
    pool.query('INSERT INTO doc_reg (username,pw) VALUES ($1,$2)',[user_name,pw_1],(err, results)=>{
        if (err){
            console.log(err)
        }
        res.render('physician/loggedin',{username:user_name})
    })
})

module.exports=router

Anything went wrong here?

If you use another way to connect with db works? For example using psql or another postgresql db client? — Gabriel Asakawa
– Gabriel Asakawa, Commented May 8, 2020 at 19:38

amit gupta · Accepted Answer · 2020-05-08 19:42:48Z

1

Generally, this error occurs when you are using the wrong password for the given user.

answered May 8, 2020 at 19:42

amit gupta

8765 silver badges8 bronze badges

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

1 Comment

TechSelfLearner Over a year ago

i swear that is the password i set up

Collectives™ on Stack Overflow

Authentication error in connecting with postgres database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related