Connection successful, no events

[gorbypark]

var PGPubsub = require('pg-pubsub');

var pubsubInstance = new PGPubsub('postgres://xxxx:xxxx@127.0.0.1/xxxx');

pubsubInstance.addChannel('testChannel');

// pubsubInstance is a full EventEmitter object that sends events on channel names
pubsubInstance.once('testChannel', function (channelPayload) {
  console.log(channelPayload);
});

The above code successfully connects to the database Successful retry attempt for pubsub but receives no notifications. On the postgres end i'm trying NOTIFY testChannel, 'Hello, world!'; and not receiving any notifications on the pg-pubsub side. Any ideas? LISTEN testChannel; and then issuing a notify command works directly on the db.

[voxpelli]

Which version of Postgres are you using?

…

19 feb. 2018 kl. 21:24 skrev Mike Hamilton ***@***.***>: var PGPubsub = require('pg-pubsub'); var pubsubInstance = new ***@***.***/xxxx'); pubsubInstance.addChannel('testChannel'); // pubsubInstance is a full EventEmitter object that sends events on channel names pubsubInstance.once('testChannel', function (channelPayload) { console.log(channelPayload); }); The above code successfully connects to the database Successful retry attempt for pubsub but receives no notifications. On the postgres end i'm trying NOTIFY testChannel, 'Hello, world!'; and not receiving any notifications on the pg-pubsub side. Any ideas? LISTEN testChannel; and then issuing a notify command works directly on the db. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[gorbypark]

Which version of Postgres are you using?

PostgreSQL 10.

[voxpelli]

I've yet to migrate my own apps that uses this module to Postgres 10, so it might be it that causes some issues.

Unfortunately Travis CI doesn't support automated tests for Postgres 10 yet, so can't easily verify it through that :/ travis-ci/travis-ci#8537

Have you tried with another Postgres version?

[cdaringe]

i am running on PG10 alpine in docker and got it running, 1st try. that never happens! ;) @gorbypark, i used this guide for extra info: http://bjorngylling.com/2011-04-13/postgres-listen-notify-with-node-js.html. not sure if you'll find it helpful or not.