Skip to content

Instantly share code, notes, and snippets.

@sedrickcz

sedrickcz/gist:73b4fdd1eba77f6617e7b7bdb9237784

Created December 22, 2016 21:19
Show Gist options
  • Save sedrickcz/73b4fdd1eba77f6617e7b7bdb9237784 to your computer and use it in GitHub Desktop.
Save sedrickcz/73b4fdd1eba77f6617e7b7bdb9237784 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
bunzip2 -f db/crawdio_production_2016-12-22-221526.sql.bz2 && psql -c "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'kingdomcomerpg_development' AND pid <> pg_backend_pid();;" ; dropdb kingdomcomerpg_development; createdb kingdomcomerpg_development; psql -d kingdomcomerpg_development < db/crawdio_production_2016-12-22-221526.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment