404 Not found error in Postgres and NodeJs api (May be duplicate)

Question

I am newbie to Nodejs. I am creating apis using node, express and Postgres DB.

   const {Pool} = require('pg');



//const connectionString = process.env.DATABASE_URL || 'postgres://localhost:5432/springmvctutorial';

var http = require("http");
var express = require('express');
const router = express.Router();
const app = express();
var bodyParser = require('body-parser');

var apiVersion = '/api/v1/';


const poo = new Pool({
  database: 'springmvctutorial',
  host: 'localhost',
  user: 'postgres',
  password : 'root',
  port: 5432,
  max: 20,
  idleTimeoutMillis: 30000,
  connectionTimeoutMillis: 2000,
})



app.use( bodyParser.json() );       // to support JSON-encoded bodies
app.use(bodyParser.urlencoded({     // to support URL-encoded bodies
  extended: true
}));

//create app server
var server = app.listen(3030,  "localhost", function () {
  var host = server.address().address
  var port = server.address().port
  console.log("Example app listening at http://%s:%s", host, port)
});


router.post('/api/v1/postData', (req, res, next) => {

  poo.connect((err, client, release) => {
    if (err) {
      return console.error('Error acquiring client', err.stack);
    }
    client.query('INSERT INTO items(text, complete) values(1,false)', (err, result) => {
      release();
      if (err) {
        return console.error('Error executing query', err.stack);
      }
      console.log(result.rows);
    });
  });

});

module.exports = router;

My table and DB has been created. I checked from Postgres CLI. But when I am running my main.js file using node main.js. It starts listening to the port on the local host but when I fire,

   http://127.0.0.1:3030/api/v1/postData

It gives 404 resource not found error.

My input from postman is ,

{
"text":"[email protected]",
"complete": true
}

can you provide us with link of you are hitting and if it is post or get? did you try to hit it by localhost ? — Basil Battikhi
– Basil Battikhi, Commented Oct 17, 2017 at 9:41

Basil Battikhi · Accepted Answer · 2017-10-17 09:51:49Z

2

try like this, i didn't test it due to i don't have the environment in this machine

const {Pool} = require('pg');
//const connectionString = process.env.DATABASE_URL || 'postgres://localhost:5432/springmvctutorial';
var http = require("http");
var express = require('express');
const app = express();
var bodyParser = require('body-parser');

var apiVersion = '/api/v1/';
const poo = new Pool({
  database: 'springmvctutorial',
  host: 'localhost',
  user: 'postgres',
  password : 'root',
  port: 5432,
  max: 20,
  idleTimeoutMillis: 30000,
  connectionTimeoutMillis: 2000,
})
app.use( bodyParser.json() );       // to support JSON-encoded bodies
app.use(bodyParser.urlencoded({     // to support URL-encoded bodies
  extended: true
}));

//create app server
app.listen(3030,  "localhost", function () {
  var host = server.address().address
  var port = server.address().port
  console.log("Example app listening at http://%s:%s", host, port)
});


app.post('/api/v1/postData', (req, res, next) => {

  poo.connect((err, client, release) => {
    if (err) {
      return console.error('Error acquiring client', err.stack);
    }
    client.query('INSERT INTO items(text, complete) values(1,false)', (err, result) => {
      release();
      if (err) {
        return console.error('Error executing query', err.stack);
      }
      console.log(result.rows);
    });
  });

});

answered Oct 17, 2017 at 9:51

Basil Battikhi

2,6682 gold badges23 silver badges36 bronze badges

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

3 Comments

Custadian Over a year ago

No @Basil, It is not working.It is throwing ReferenceError: server is not defined. I think, we need var server to get address and port.

Basil Battikhi Over a year ago

Well, i told you because i don't have the environment in this machine please remove var host = server.address().address var port = server.address().port they are useless now and let me know if do you have any update :)

Custadian Over a year ago

After removing server referenced code. It worked. Can you please tell me why it was happening so that I will not repeat in future because the same code was working with MySql.(Server port listening code.)

Collectives™ on Stack Overflow

404 Not found error in Postgres and NodeJs api (May be duplicate)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related