PgAdmin Terminate Session for Azure PostgreSQL
I have created an Azure for Postgresql flexible server and I connected to pgAdmin using admin credentials.
When I try to terminate a user session, I get the following error:
superuser privileges are required to terminate another user query
Could you please help?
Hi @Kopl Thanks for posting your question in the Microsoft Q&A forum.
As we understand you are tring to terminate a user session and you are facing an issue.
Which user are you using and which user has created the session you want to terminate? could you please provide more information.
you can checkout here for documention
Hi @GeethaThatipatri-MSFT ,
Thank you for your help. I am trying to terminate the session for a newly created user using the admin user (that I have supplied while creating the instance).
@Kopl pgadmin kill still relies on functions (pg_terminate_backend or pg_cancel_backend)
Please check this document here
Hi, @Kopl Did you get a chance to check my above reply?
I can confirm this works on PostgreSQL Single Server (run from pgAdmin).
Sign in to comment