can't connect to postgreSQL database with express

Question

I downloaded and installed postgreSQL on my windows machine, i also downloaded pgAdmin 4 for the user interface. I'm working on a node-js project But i can't connect to my database. I'm using knex, Here is my code

     const PORT = 3001;
     const bcrypt = require('bcrypt');
     const saltRounds = 10;
     const express = require('express');
     const bodyParser = require('body-parser');
     const cors = require('cors');
     const app = express();
     const knex = require('knex');

    const db = knex({
         client: 'pg',
         connection: {
             host : 'localhost',
             user : '',
             password : '',
             database : 'SmartBrain'
             }
   });

   db.select('*').from('users').then(resp => console.log(resp));

I'm getting this error :

app is running on port 3001
Unhandled rejection error: role "MostfaWindows" is not permitted to lo                        g in
    at Connection.parseE (C:\Users\MostfaWindows\Desktop\faceRecogniti                        onApi\node_modules\pg\lib\connection.js:553:11)
    at Connection.parseMessage (C:\Users\MostfaWindows\Desktop\faceRec                        ognitionApi\node_modules\pg\lib\connection.js:378:19)
    at Socket. (C:\Users\MostfaWindows\Desktop\faceRecognit                        ionApi\node_modules\pg\lib\connection.js:119:22)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    at addChunk (_stream_readable.js:263:12)
    at readableAddChunk (_stream_readable.js:250:11)
    at Socket.Readable.push (_stream_readable.js:208:10)
    at TCP.onread (net.js:594:20)

"MostfaWindows" is my computer name. Any help would be much appreciated, thank you.

Your configuration for connecting to Postgres is incorrect. Check the values for localhost, the database port, the database user and the database password. — laaksom
– laaksom, Commented Jul 17, 2018 at 3:22
In my pgAdmin i have this URL, should i put this instead of localhost? "127.0.0.1:65480/browser" — Mustapha Gheribi
– Mustapha Gheribi, Commented Jul 17, 2018 at 3:23

Mustapha Gheribi · Accepted Answer · 2018-07-17 04:08:29Z

1

I solved the problem by simply creating a user, granting it select priviliges and putting the user name in the user field in connection.

answered Jul 17, 2018 at 4:08

Mustapha Gheribi

568 bronze badges

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

Collectives™ on Stack Overflow

can't connect to postgreSQL database with express

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