Is it possible to create event triggers in Azure postgresql?

Question

As it is not possible to login as superuser in postgre, according to Azure documentation, only Microsoft is part of superuser role:

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-security

And according to postgre official documentation, event triggers can only be run by superusers:

https://www.postgresql.org/docs/14/sql-createeventtrigger.html

I was wondering if there is any way to create event triggers in Azure postgre database.

Thanks!

Answer 1

Hi,@reces Thanks for posting your question in the Microsoft Q&A forum.

I understand you want to know if it is possible to create event triggers in Azure PostgreSQL, given that only Microsoft is part of the superuser role according to Azure documentation, and event triggers can only be run by superusers

Yes, an event trigger is not supported, you can use the pg_notify and integrate it with the event grid for example for real-time event processing , or whatever notification system  : https://github.com/Azure/azure-postgresql/tree/master/samples/EventGrid%20Demo

I hope this information helps.

Regards

Geetha