Getting permission issue for pg_signal_backend in postgre16 in azure flexible server

Saksham Joshi 5 Reputation points
2024-04-22T13:28:02.0766667+00:00

Hi,We recently commisioned a new flexible server using latest postgresql 16 and at the same time created an Microsoft entra administrator for our server.After that we created a database 'Test' using our Microsoft entra administrator.Then when we intended to terminate our idle connections we found that our administrator can only terminate those db sessions that are started using administrator only and another db sessions of different users are not allowed to be terminated.We also tried to run below statement "Grant pg_signal_backend to 'administrator'" but it returned the following error that 'permission denied to grant role "pg_signal_backend" Detail:Only roles with the Admin option on role "pg_signal_backend" may grant this role.We also tested the same on postgres 15 and no such issue was encountered.

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

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
    2024-04-22T14:06:29.78+00:00

    @Saksham Joshi Welcome to Microsoft Q&A thanks for posting your question.

    We have a similar question on the Q&A forum which you can follow here also please find the limitations on PG 16 release https://www.postgresql.org/docs/current/release-16.html

    https://video2.skills-academy.com/en-gb/answers/questions/1611010/azure-postgres-flexible-pg-signal-backend?comment=question#newest-question-comment

    If you need more information, please do let me know.

    Regrads

    Geetha

    0 comments No comments