early timeout on LISTEN query

[Lheurt]

I properly receive "notification" events when I issue a LISTEN query, but the connection seems to timeout rather fast (about 15 seconds in). I can't seem to find anyway to prevent the timeout or catch it when it happens. Any existing solution to this ?

pg.connect(pgConnectionString, function(err, client) {
    client.query('LISTEN "watcher"');
    client.on('notification', function(data) {
        console.log(data.payload);
    });
});

[brianc]

pg.connect is use to create pooled connections. Using a connection pool connection for listen events really isn't supported or a good idea though I can see how this could be a very easy mistake to make.

To 'listen' a connection by definition must stay open permanently. For a connection to stay open permanently it can never be returned to the connection pool.

Try creating a stand-alone client when you need to handle listen events:

var client = new Client(pgConnectionString);
client.connect();
client.query('LISTEN "watcher"');
client.on('notification', function(data) {
});

<3

[Lheurt]

Thanks a lot for the clarification. I've updated my script with your example and everything's fine now.