Skip to content

Instantly share code, notes, and snippets.

@willm

willm/postgres_cheat.md

Created January 23, 2018 10:28
Show Gist options
  • Save willm/5caf1d3bd5210a82362e1bdbcc1f7c1a to your computer and use it in GitHub Desktop.
Save willm/5caf1d3bd5210a82362e1bdbcc1f7c1a to your computer and use it in GitHub Desktop.
Download ZIP
Postgres cheat sheet
Raw
postgres_cheat.md

Kill all sessions for a db

select pg_terminate_backend(pid)
from pg_stat_activity
where datname = 'doomed_database'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment