node-postgres: Not working issuing a NOTIFY job from postgres CLI

Question

I have some code thats works Ok in PHP. From the postgres CLI I issue a

NOTIFY job;

The notification is correctly raised by Postgres ( I can see it in the PHP client), but can't read it in node.

JS:

var pg = require('pg');
var conString = "your postgres information";
var client = new pg.Client(conString);

client.connect();
client.query('LISTEN job');
client.on('notification', function(msg) {
    console.log('data');
});

I would prefer to keep it simple. Is the only way to make a procedure in postgres like this?

Ok, the problem was in the conString var conString = "tcp://user:pass@localhost/db"; I was connected to the generic postgres db, and not the correct one. — Martin Romañuk
– Martin Romañuk, Commented Nov 19, 2012 at 18:40
Please post that as an answer and accept it when the timer lets you. I'll upvote if you leave a comment here when you've done so. Thanks for following up. — Craig Ringer
– Craig Ringer, Commented Nov 20, 2012 at 0:10

Martin Romañuk · Accepted Answer · 2012-11-21 10:51:48Z

3

Ok, the problem was in the conString parameter.

var conString = "tcp://user:pass@localhost/db";

Is important to check that you are using the correct database to reach the notification messages.

edited Nov 21, 2012 at 10:51

answered Nov 20, 2012 at 3:41

Martin Romañuk

1,11010 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

node-postgres: Not working issuing a NOTIFY job from postgres CLI

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related