PostgreSQL Commands

postgres.sql

-- Query a parameter
SHOW max_connections;
RESET max_connections;
SHOW ALL;

SELECT * FROM pg_settings;
SELECT *
FROM   pg_settings
WHERE  name = 'max_connections';

-- Force drop db with active connections > 9.2
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB'
  AND pid <> pg_backend_pid();
  
-- Show active connections
SELECT * FROM pg_stat_activity;