Sean Culver seanculver
seanculver
/ gist:7056855
Created
October 19, 2013 14:45
— forked from ebinion/gist:5690817
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE pg_database SET datallowconn = TRUE where datname = 'template0'; | |
| \c template0 | |
| UPDATE pg_database SET datistemplate = FALSE where datname = 'template1'; | |
| drop database template1; | |
| create database template1 with template = template0 encoding = 'UNICODE' LC_CTYPE = 'en_US.UTF-8' LC_COLLATE = 'C'; | |
| UPDATE pg_database SET datistemplate = TRUE where datname = 'template1'; | |
| \c template1 | |
| UPDATE pg_database SET datallowconn = FALSE where datname = 'template0'; |
seanculver
/ purge.sh
Last active
December 25, 2015 23:39
— forked from adrienbrault/purge.sh
Updated for debian
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # Credits to: | |
| # - http://vstone.eu/reducing-vagrant-box-size/ | |
| # - https://github.com/mitchellh/vagrant/issues/343 | |
| aptitude -y purge ri | |
| aptitude -y purge installation-report landscape-common wireless-tools wpasupplicant ubuntu-serverguide | |
| aptitude -y purge python-dbus libnl1 python-smartpm python-twisted-core libiw30 | |
| aptitude -y purge python-twisted-bin libdbus-glib-1-2 python-pexpect python-pycurl python-serial python-gobject python-pam python-openssl libffi5 |