jamesjohnson

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

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

CREATE TABLE users (

jamesjohnson

#!/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

jamesjohnson

#!/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

jamesjohnson

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