PSQL command to help with session termination

I find the following PSQL command quite useful for terminating session for a specific database in Postgres.



Let say you want to alter the database name but there's tons of connections. 

ALTER DATABASE "keycloak" RENAME TO "keycloakcurrent"


So first you see which process is active in the database 

SELECT * FROM pg_stat_activity where datname='keycloak'

Then you issue multiple command to terminate the session. 

SELECT pg_terminate_backend(9026)


If you bump into an error whereby you need to be a member of pg_signal_backend, then you can use this command to grant yourself a member to that role called pg_signal_backend.


GRANT pg_signal_backend TO psqladmin




Comments

Post a Comment

Popular posts from this blog

The specified initialization vector (IV) does not match the block size for this algorithm

Image
If you're getting  exception when trying to assigned key to a symmetric key and getting error message below :- The specified initialization vector (IV) does not match the block size for this algorithm And your code probably look like something below :- Then you need to go into debug mode and start looking into the supported size for IV as shown in diagram below :- As you can see, IV is 16 bytes, so you need to provide 16 bytes. The same goes for Key field too, if you're adding anything to it. As long as you provide a valid key size, then we're good and you're code will be ready.
Read more