Introduction to Listen and Notify

Learn about how to enable notifications in PostgreSQL.

The PostgreSQL protocol includes a streaming protocol with COPY and also implements asynchronous messages and notifications. This means that as soon as a connection is established with PostgreSQL, the server can send messages to the client even when the client is idle.

PostgreSQL notifications

Messages that flow from the server to the connected client should be processed by the client. It could be that the server is being restarted or an application message is being delivered.

Get hands-on with 1200+ tech skills courses.