Score:0

Manually close database connections for AWS Aurora Serverless PostgresDB?

cn flag

Is there any way to manually close all open connections to an AWS Aurora Serverless Postgres database? Because the database is serverless, it is not possible to restart the database.

vn flag
I can't recall if the root user has the right privileges, but https://stackoverflow.com/questions/5108876/kill-a-postgresql-session-connection perhaps?
Thijmen avatar
cn flag
Not the proper rights unfortunately. For this and some other reasons I've decided to refrain from serverless DB hosting altogether right now.
vn flag
Do you have access to the user the connections are for? https://stackoverflow.com/questions/22713375/permissions-for-pg-terminate-backend-on-amazon-rds
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.