HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Not a able to kill the DB session in Postgres RDS

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
killthepostgressessionrdsnotable

Problem

We are trying to killing one of DB session but not able to do it. Tried with following command getting "TRUE" after issuing command. Still we can see the session is active.

select pg_terminate_backend(933);

pg_terminate_backend
t (1 row)

session:

933 | -1 days -01:51:38.165893 | test | SELECT col1,col2,col3 FROM test_table "PC0" WHERE ( col1 LIKE $1 ) ORDER BY 3 ASC;


can anyone please help me to resolve this.
We are using Postgres-9.3 RDS

Solution

I found the answer to this on stack overflow, basically you don't have rdsadmin privileges so you can only terminate sessions for your own username. https://stackoverflow.com/questions/22713375/permissions-for-pg-terminate-backend-on-amazon-rds

Context

StackExchange Database Administrators Q#207570, answer score: 3

Revisions (0)

No revisions yet.