On Tue, Aug 29, 2017 at 10:21 AM, Daniel Verite <dan...@manitou-mail.org> wrote:
> Jerry Regan wrote: > > > I think I could justify the effort to ‘script’ psql. I’m not so sure I > can > > justify the effort to write a standalone program. > > As a hack around psql, you could have a script that feeds psql > with "SELECT 1" from time to time and capture only the > notifications output: > > (echo "listen foo;"; while true; do echo "select 1;"; sleep 1; done) | \ > psql | grep notification > > When another session issues NOTIFY foo, 'bar' > that output filtered by the above command is, for example: > > Asynchronous notification "foo" with payload "bar" received from > server process with PID 20033. > > which just needs to be piped into another step that runs your custom > action. > Sounds like a job for "expect". https://www.tcl.tk/man/expect5.31/expect.1.html > > > Best regards, > -- > Daniel Vérité > -- Caution! The OP is an hyperpolysyllabicsesquipedalianist and this email may cause stress to those with hippopotomonstrosesquipedaliophobia. Maranatha! <>< John McKown
