Node-postgres is connecting to localhost instead of AWS Postgres Instance

Question

I am new to NodeJS and PostgreSQL, I would like to seek your help regarding to my problem connecting to AWS Postgres Instance. My Nodejs keeps on connecting to my localhost instead of AWS Postgres Instance. Below are my server.js and package.json.

server.js

const express    = require('express');
const { Client } = require('pg');
const app        = express();

const client = new Client({
    host: 'db-postgresql.abcdefghi.ap-southeast-1.rds.amazonaws.com',
    port: 5432,
    user: 'db_instance',
    password: 'my_password'
});

client.connect((err) => {
    if (err) {
        console.error('connection error', err.stack)
    } else {
        console.log('connected')
    }
})

app.listen(5000, () => {
    console.log('listening on port 5000');
});

Package.json

{
    "name": "NodeJS PostgreSQL",
    "version": "2.0.0",
    "description": "DB Connect",
    "main": "server.js",
    "scripts": {
        "test": "echo \"Error: no test specified\" && exit 1",
        "start": "nodemon server.js"
     },
    "author": "Mac Pertubal",
    "license": "ISC",
    "dependencies": {
       "express": "^4.16.3",
       "pg": "^7.5.0"
     },
    "devDependencies": {
    "nodemon": "^1.18.4"
   }
 }

You should specify the "database" attribute in the Client definition too. — Mahesh H Viraktamath
– Mahesh H Viraktamath, Commented Oct 12, 2018 at 11:49
Hi Mahesh, what do you mean "database" attribute in the Client definition? — Raymark Pertubal
– Raymark Pertubal, Commented Oct 12, 2018 at 11:56
const client = new Client({ user: 'dbuser', host: 'database.server.com', database: 'mydb', password: 'secretpassword', port: 3211, }) — Mahesh H Viraktamath
– Mahesh H Viraktamath, Commented Oct 12, 2018 at 11:57
To clarify, is this deployed somewhere or are you running it locally? Can you add the error logs to your question? — RangerRanger
– RangerRanger, Commented Oct 12, 2018 at 21:10

Raymark Pertubal · Accepted Answer · 2018-10-15 02:45:54Z

1

I finally figure it out, I forgot to include the database name is my database settings.

Before

const client = new Client({
    host: 'db-postgresql.abcdefghi.ap-southeast-1.rds.amazonaws.com',
    port: 5432,
    user: 'db_instance',
    password: 'my_password'
});

After

const client = new Client({
    host: 'db-postgresql.abcdefghi.ap-southeast-1.rds.amazonaws.com',
    port: 5432,
    user: 'db_instance',
    password: 'my_password',
    database: 'database_name'
});

Thank you so much for trying to solve my problem.

answered Oct 15, 2018 at 2:45

Raymark Pertubal

431 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Node-postgres is connecting to localhost instead of AWS Postgres Instance

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