listen.php

<?php
// This file listen to notifications from the Postgresql server.
// To send a notification with a payload you can either issue a NOTIFY SQL command from a psql console
// or use the file below.
// pomm https://github.com/chanmix51/Pomm

$database = new \Pomm\Connection\Database([ "dsn" => "pgsql://user:pass@host:port/name" ]);
$observer = $database->getConnection()
    ->createObserver()
    ->listen('plop');

while (true)
{
    while(!$data = $observer->getNotification())
    {
        printf(".");
        sleep(1);
    }

    printf("x\n");
    var_dump($data);
}

notify.php

<?php


$database = new \Pomm\Connection\Database([ "dsn" => "pgsql://user:pass@host:port/name" ]);

$database->getConnection()->notify('plop', 'some data');