vimalkumar.in

Today I had to disable access to some PostgreSQL databases temporarily. This can be easily done using pgAdmin. Under database properties, set "Connection Limit " to 0 from the default of -1. The corresponding SQL statement is

ALTER DATABASE "dbname" WITH CONNECTION LIMIT = 0;