James Johnson jamesjohnson

## README.md

      
              3 files
            
          
              1 fork
            
          
              0 comments
            
          
              2 stars
            
          
                jamesjohnson
                / README.md
            
            
              Created
              February 19, 2012 22:07
                — forked from dlo/README.md
            
              
                Ubuntu 11.10, PostGIS 1.5 Setup Script
              
          
    Installing PostGIS

Ubuntu 11.10

sudo apt-get install postgresql-9.1-postgis
sudo su postgres
bash <(curl -s https://raw.github.com/gist/18660599/create_template.sh)

Ubuntu 11.04


## aws_installer.sh
#!/usr/bin/bash

#This will set up your machine for using django 1.4

sudo add-apt-repository -y ppa:pitti/postgresql
sudo add-apt-repository -y ppa:git-core/ppa
sudo add-apt-repository -y ppa:bchesneau/gunicorn
sudo add-apt-repository -y ppa:nginx/stable
sudo add-apt-repository -y ppa:natecarlson/haproxy # For Load Balancing
sudo apt-get update -y

## gist:2974809
#!/usr/bin/bash

#This will set up your machine for using django 1.4

sudo add-apt-repository -y ppa:pitti/postgresql
sudo add-apt-repository -y ppa:git-core/ppa
sudo add-apt-repository -y ppa:bchesneau/gunicorn
sudo add-apt-repository -y ppa:nginx/stable
sudo add-apt-repository -y ppa:natecarlson/haproxy # For Load Balancing
sudo apt-get update -y

## SQL
DROP USER testdb;
CREATE USER testdb;
ALTER DATABASE testdb OWNER to testdb;

CREATE TABLE companys (
    id SERIAL PRIMARY KEY,
    name TEXT
);

CREATE TABLE users (
	#!/usr/bin/bash

	#This will set up your machine for using django 1.4

	sudo add-apt-repository -y ppa:pitti/postgresql
	sudo add-apt-repository -y ppa:git-core/ppa
	sudo add-apt-repository -y ppa:bchesneau/gunicorn
	sudo add-apt-repository -y ppa:nginx/stable
	sudo add-apt-repository -y ppa:natecarlson/haproxy # For Load Balancing
	sudo apt-get update -y
	DROP USER testdb;
	CREATE USER testdb;
	ALTER DATABASE testdb OWNER to testdb;

	CREATE TABLE companys (
	id SERIAL PRIMARY KEY,
	name TEXT
	);

	CREATE TABLE users (