Skip to content

Instantly share code, notes, and snippets.

@rastasheep

rastasheep/pg_9.4.sh

Last active July 11, 2017 20:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rastasheep/4b7bf6ce1344dc0c00a0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rastasheep/4b7bf6ce1344dc0c00a0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. rastasheep revised this gist Apr 6, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion pg_9.4.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@ sudo apt-get remove -y postgresql-client-9.3 postgresql-9.3 postgresql-contrib-9
    wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
    echo " deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" | sudo tee -a /etc/apt/sources.list
    sudo apt-get update
    sudo apt-get -y --force-yes install postgresql-9.4
    sudo apt-get -y --force-yes install postgresql-9.4 postgresql-contrib-9.4
    sudo su - postgres -c "pg_dropcluster --stop 9.4 main"
    sudo su - postgres -c "pg_createcluster --start -e UTF-8 9.4 main"
    sudo su - postgres -c "psql -c \"CREATE USER runner WITH PASSWORD 'semaphoredb';\" -d template1"
  2. rastasheep revised this gist Feb 24, 2015. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion pg_9.4.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -6,4 +6,5 @@ sudo apt-get -y --force-yes install postgresql-9.4
    sudo su - postgres -c "pg_dropcluster --stop 9.4 main"
    sudo su - postgres -c "pg_createcluster --start -e UTF-8 9.4 main"
    sudo su - postgres -c "psql -c \"CREATE USER runner WITH PASSWORD 'semaphoredb';\" -d template1"
    sudo su - postgres -c "psql -c \"ALTER USER runner CREATEUSER CREATEDB;\" -d template1"
    sudo su - postgres -c "psql -c \"ALTER USER runner CREATEUSER CREATEDB;\" -d template1"
    sudo service postgresql start || true
  3. rastasheep created this gist Jan 6, 2015.
    9 changes: 9 additions & 0 deletions pg_9.4.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,9 @@
    sudo apt-get remove -y postgresql-client-9.3 postgresql-9.3 postgresql-contrib-9.3 postgresql-server-dev-9.3
    wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
    echo " deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" | sudo tee -a /etc/apt/sources.list
    sudo apt-get update
    sudo apt-get -y --force-yes install postgresql-9.4
    sudo su - postgres -c "pg_dropcluster --stop 9.4 main"
    sudo su - postgres -c "pg_createcluster --start -e UTF-8 9.4 main"
    sudo su - postgres -c "psql -c \"CREATE USER runner WITH PASSWORD 'semaphoredb';\" -d template1"
    sudo su - postgres -c "psql -c \"ALTER USER runner CREATEUSER CREATEDB;\" -d template1"