PgAdmin Terminate Session for Azure PostgreSQL

Question

Kopl 166

Hello team,

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?

Thanks!

GeethaThatipatri-MSFT 16,396 Reputation points Microsoft Employee

2022-08-15T15:50:55.013+00:00

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

Regards
Geetha
Kopl 166 Reputation points

2022-08-15T15:54:26.633+00:00

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).

Thanks!
GeethaThatipatri-MSFT 16,396 Reputation points Microsoft Employee

2022-08-16T19:15:07.697+00:00

@Kopl pgadmin kill still relies on functions (pg_terminate_backend or pg_cancel_backend)
Please check this document here

Regards
Geetha
GeethaThatipatri-MSFT 16,396 Reputation points Microsoft Employee

2022-08-22T15:07:01.057+00:00

Hi, @Kopl Did you get a chance to check my above reply?

Regards
Geetha
Rafi Trad 56 Reputation points

2022-11-16T14:40:07.87+00:00

I can confirm this works on PostgreSQL Single Server (run from pgAdmin).

GeethaThatipatri-MSFT 16,396 Reputation points Microsoft Employee

2022-08-15T15:50:55.013+00:00

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

Regards
Geetha
Kopl 166 Reputation points

2022-08-15T15:54:26.633+00:00

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).

Thanks!
GeethaThatipatri-MSFT 16,396 Reputation points Microsoft Employee

2022-08-16T19:15:07.697+00:00

@Kopl pgadmin kill still relies on functions (pg_terminate_backend or pg_cancel_backend)
Please check this document here

Regards
Geetha
GeethaThatipatri-MSFT 16,396 Reputation points Microsoft Employee

2022-08-22T15:07:01.057+00:00

Hi, @Kopl Did you get a chance to check my above reply?

Regards
Geetha
Rafi Trad 56 Reputation points

2022-11-16T14:40:07.87+00:00

I can confirm this works on PostgreSQL Single Server (run from pgAdmin).