Is it possible to create event triggers in Azure postgresql?

reces 20 Reputation points
2023-09-29T14:00:22.62+00:00

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!

Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 27,972 Reputation points Microsoft Employee
    2023-09-29T20:32:20.77+00:00

    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

    0 comments No comments

0 additional answers

Sort by: Most helpful