Skip to content

Instantly share code, notes, and snippets.

@m87carlson

m87carlson/take-postgres-db-offline.sql

Created March 23, 2016 16:09
Show Gist options
  • Save m87carlson/254697cc014f69e401c7 to your computer and use it in GitHub Desktop.
Save m87carlson/254697cc014f69e401c7 to your computer and use it in GitHub Desktop.
Download ZIP
Take a postgres database "mydb" offline
Raw
take-postgres-db-offline.sql
update pg_database set datallowconn = false where datname = 'mydb';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment