lucasallan · September 6, 2011 21:03 · Sep 11, 2011 · Jul 20, 2011 · Jul 14, 2011 · Jul 14, 2011
diff --git a/install_postgis_osx.sh b/install_postgis_osx.sh
@@ -14,6 +14,18 @@ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
 createdb postgis_template
 createlang plpgsql postgis_template
 
+#If encountering errors like these:
+
+#createuser: could not connect to database postgres: could not connect to server: Permission denied
+#    Is the server running locally and accepting
+#    connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
+#
+#try:
+curl http://nextmarvel.net/blog/downloads/fixBrewLionPostgres.sh | sh
+#
+#more information: http://nextmarvel.net/blog/2011/09/brew-install-postgresql-on-os-x-lion/
+
+
 #[Mac OSX] Import Postgis Data
 psql -d postgis_template -f /usr/local/Cellar/postgis/1.5.3/share/postgis/postgis.sql
 psql -d postgis_template -f /usr/local/Cellar/postgis/1.5.3/share/postgis/spatial_ref_sys.sql

diff --git a/install_postgis.sh → install_postgis_osx.sh b/install_postgis.sh → install_postgis_osx.sh
@@ -1,29 +1,27 @@
 # Some good references are:
 # http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x
 # http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/
+# http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2630392
 
+#1. Install PostgreSQL postgis and postgres
 
-#Installs postgis and postgres
 brew install postgis
-
-#Do it only at first start
 initdb /usr/local/var/postgres
-
-#Starts the database manually
 pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
 
-#Creates a template to be used on creating GIS-enabled databases
+#2. Create a template to be used on creating GIS-enabled databases
+
 createdb postgis_template
 createlang plpgsql postgis_template
 
-#Import Postgis Data
+#[Mac OSX] Import Postgis Data
 psql -d postgis_template -f /usr/local/Cellar/postgis/1.5.3/share/postgis/postgis.sql
 psql -d postgis_template -f /usr/local/Cellar/postgis/1.5.3/share/postgis/spatial_ref_sys.sql
 
 #Test if works
 psql -d postgis_template -c "SELECT postgis_full_version();"
 
-#Permissions
+#3. Set template permissions to gisgroup
 createuser -R -S -L -D -I gisgroup;
 
 psql -d postgis_template
@@ -33,13 +31,12 @@ ALTER TABLE spatial_ref_sys OWNER TO gisgroup;
 CREATE SCHEMA gis_schema AUTHORIZATION gisgroup;
 \q
 
-
-#Adds an app user
+#4. Adds an app to your application
 createuser -i -l -S -R -d <app_user>
 
 psql -d postgres
 GRANT gisgroup TO <app_user>;
 \q
 
-#Database creation
-createdb -T postgis_template -O <app_user> <app_db>
+#5. Create your app database
+createdb -T postgis_template -O <app_user> <app_db>;
diff --git a/install_postgis_ubuntu.sh b/install_postgis_ubuntu.sh
@@ -0,0 +1,43 @@
+# Some good references are:
+# http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x
+# http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/
+# http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2630392
+
+#1. Install PostgreSQL postgis and postgres
+
+sudo apt-get install postgresql-8.4 postgresql-client-8.4 postgresql-contrib-8.4
+sudo apt-get install postgresql-8.4-postgis
+
+#2. Create a template to be used on creating GIS-enabled databases
+
+sudo su postgres
+
+createdb postgis_template
+createlang plpgsql postgis_template
+
+#Import Postgis Data
+psql -d postgis_template -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
+psql -d postgis_template -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql
+
+#Test if works
+psql -d postgis_template -c "SELECT postgis_full_version();"
+
+#3. Set template permissions to gisgroup
+createuser -R -S -L -D -I gisgroup;
+
+psql -d postgis_template
+ALTER DATABASE postgis_template OWNER TO gisgroup;
+ALTER TABLE geometry_columns OWNER TO gisgroup;
+ALTER TABLE spatial_ref_sys OWNER TO gisgroup;
+CREATE SCHEMA gis_schema AUTHORIZATION gisgroup;
+\q
+
+#4. Adds an app to your application
+createuser -i -l -S -R -d <app_user>
+
+psql -d postgres
+GRANT gisgroup TO <app_user>;
+\q
+
+#5. Create your app database
+createdb -T postgis_template -O <app_user> <app_db>;
diff --git a/install_postgis.sh b/install_postgis.sh
@@ -27,6 +27,7 @@ psql -d postgis_template -c "SELECT postgis_full_version();"
 createuser -R -S -L -D -I gisgroup;
 
 psql -d postgis_template
+ALTER DATABASE postgis_template OWNER TO gisgroup;
 ALTER TABLE geometry_columns OWNER TO gisgroup;
 ALTER TABLE spatial_ref_sys OWNER TO gisgroup;
 CREATE SCHEMA gis_schema AUTHORIZATION gisgroup;

diff --git a/install_postgis.sh b/install_postgis.sh
@@ -0,0 +1,44 @@
+# Some good references are:
+# http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x
+# http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/
+
+
+#Installs postgis and postgres
+brew install postgis
+
+#Do it only at first start
+initdb /usr/local/var/postgres
+
+#Starts the database manually
+pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
+
+#Creates a template to be used on creating GIS-enabled databases
+createdb postgis_template
+createlang plpgsql postgis_template
+
+#Import Postgis Data
+psql -d postgis_template -f /usr/local/Cellar/postgis/1.5.3/share/postgis/postgis.sql
+psql -d postgis_template -f /usr/local/Cellar/postgis/1.5.3/share/postgis/spatial_ref_sys.sql
+
+#Test if works
+psql -d postgis_template -c "SELECT postgis_full_version();"
+
+#Permissions
+createuser -R -S -L -D -I gisgroup;
+
+psql -d postgis_template
+ALTER TABLE geometry_columns OWNER TO gisgroup;
+ALTER TABLE spatial_ref_sys OWNER TO gisgroup;
+CREATE SCHEMA gis_schema AUTHORIZATION gisgroup;
+\q
+
+
+#Adds an app user
+createuser -i -l -S -R -d <app_user>
+
+psql -d postgres
+GRANT gisgroup TO <app_user>;
+\q
+
+#Database creation
+createdb -T postgis_template -O <app_user> <app_db>
No results found