grgichtran

stuff and things

Menu
  • Home
  • His
  • Hers
  • Contact
Browse: Home » 2014 » August

Postgresql – Drop connections script

August 21, 2014 · by admin · in His

Select another database in pgadmin and execute this script to drop all connected users. Script — view active connections SELECT * FROM pg_stat_activity WHERE datname=’DBNAME’; — drop active connections SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE datname=’DBNAME’;– view active connections select *…

Google Ads

About

A blog about stuff as most blogs generally are.

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 grgichtran

Powered by WordPress and Origin