Not a able to kill the DB session in Postgres RDS
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