Support PostgreSQL event-listener plugin

[nqvuong1998]

PostgreSQL is widely used, but Trino only has MySQL and HTTP event listener plugins. It is essential to add support for PostgreSQL.

[nqvuong1998]

cc @mosabua

[hashhar]

IMO the MySQL, Kafka and HTTP event listeners should also live out-of-tree. the SPI is there and community can build and maintain various event listener implementations.

At this rate we'll have one for SQLServer, Oracle, Pulsar and maybe more.

[mosabua]

If there is anyone willing to contribute a PostgreSQL event listener .. thats fair game. Feel free to send a PR @nqvuong1998 .. it might even be worth to look at a similar approach as we have for connectors with the BaseJdbcConnector to make implementation easier.

In terms of in the main repo or elsewhere as suggested by @hashhar .. for now we would want to go with in the main repo since we are not set up for release process and more with external separate repos and the same reasoning of getting plugins out would apply for connectors.

Note that we are trying to improve all that with smarter packaging as well - details in #22597

[harksin]

so there is a kafka event listener already ?
interesting to know where :)

[mosabua]

i am just about to merge the docs pr .. has been in the last two releases

[mosabua]

#23158

[posulliv]

I wrote a simple one for MYSQL in the past - https://github.com/posulliv/trino-simple-db-logger

It uses flyway for creating the necessary table in MySQL so you could easily add the SQL for PostgreSQL if you wanted.

[mosabua]

Note that the version from @posulliv is great since it uses flyway .. but is out of date with trino. So if someone starts new .. use the trino project mysql event listener as base and then maybe add the flyway stuff