I'm struggling with PostgreSQL LISTEN - NOTIFY mechanism. I open two consoles and connect to my database using psql client:
psql -U postgres test_db
In the first console I subscribe to some notification:
test_db=# listen event; LISTEN
In the second console I'm trying to send a notification:
test_db=# notify event; NOTIFY
And nothing happens in the first console. But if I send a notification from console 1, I get it and also I get all previous notifications from console 2.
I use PostgreSQL 9.2.1 under CentOS 6.5 x64.