Changes between Version 26 and Version 27 of GIS/InstallationGuidelines/Linux

Timestamp:

09/19/10 18:02:16 (14 years ago)

Author:

Fran Boon

Comment:

--

GIS/InstallationGuidelines/Linux

@@ -18 +18 @@
 psql -d gis -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql
 }}}
- * Add Spherical Mercator projection (900913. See http://www.cadmaps.com/gisblog/?p=81 for 54004):
-{{{
-# Not needed with PostGIS-1.5 :)
-#psql gis
-#INSERT into spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) values (900913 ,'EPSG',900913,'GEOGCS["WGS 84", DATUM["World Geodetic System 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563,AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], NIT["degree",0.017453292519943295], AXIS["Longitude", EAST], AXIS["Latitude", NORTH],AUTHORITY["EPSG","4326"]], PROJECTION["Mercator_1SP"],PARAMETER["semi_minor", 6378137.0], PARAMETER["latitude_of_origin",0.0], PARAMETER["central_meridian", 0.0], PARAMETER["scale_factor",1.0], PARAMETER["false_easting", 0.0], PARAMETER["false_northing", 0.0],UNIT["m", 1.0], AXIS["x", EAST], AXIS["y", NORTH],AUTHORITY["EPSG","900913"]] |','+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs');
-}}}
- * Allow remote access:
-{{{
-passwd postgres
-
-vim /etc/postgresql/8.4/main/postgresql.conf
-listen_addresses = '*'
-
-vim /etc/postgresql/8.4/main/pg_hba.conf
-host    all         all         my.ip.add.ress/24     md5
-
-/etc/init.d/postgresql restart
-
-vim /etc/iptables.rules
--A INPUT -p tcp --dport 5432 -j ACCEPT
-
-reboot
-
+
+Add Spherical Mercator projection (900913. See http://www.cadmaps.com/gisblog/?p=81 for 54004):
+ * Not needed with PostGIS-1.5 :)
+{{{
+psql gis
+INSERT into spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) values (900913 ,'EPSG',900913,'GEOGCS["WGS 84", DATUM["World Geodetic System 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563,AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], NIT["degree",0.017453292519943295], AXIS["Longitude", EAST], AXIS["Latitude", NORTH],AUTHORITY["EPSG","4326"]], PROJECTION["Mercator_1SP"],PARAMETER["semi_minor", 6378137.0], PARAMETER["latitude_of_origin",0.0], PARAMETER["central_meridian", 0.0], PARAMETER["scale_factor",1.0], PARAMETER["false_easting", 0.0], PARAMETER["false_northing", 0.0],UNIT["m", 1.0], AXIS["x", EAST], AXIS["y", NORTH],AUTHORITY["EPSG","900913"]] |','+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs');
+}}}
+
+Create a user to access the db:
+{{{
 su postgres
 createuser -s -P gis
-}}}
-(Don't do remote access as 'postgres' - to do so means can't simply access psql via 'su postgres')
-
- * Adjust postgresql.conf for performance relative to resources available (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
-{{{
-vim /etc/sysctl.conf
-# Increase Shared Memory available for PostgreSQL
-# 512Mb
-kernel.shmmax = 279134208
-# 1024Mb (may need more)
-#kernel.shmmax = 536870912
-kernel.shmall = 2097152
-
-sysctl -w kernel.shmmax=58720256
-sysctl -w kernel.shmall=2097152
-
-vim /etc/postgresql/8.4/main/postgresql.conf
-
-# This default is probably ok
-# adjust upward _or_ add a connection pooling layer like pgpool if running out of connections for clients
-max_connections = 100
-
-# shared_buffers = 24MB
-# Ideal is if all frequently accessed indexes and table rows can fit in here - this is often unrealistic
-# setting too high relative to system resources can be detrimental to the system.
-# At the high end this should be no more than 1/4 to 1/3 the available memory (ie that which is not being used by the OS or other processes).
-# Values suggested are quite conservative, so you can push them up a bit if there are resources available for it
-# but absolutely no more than 1/3 available memory.
-# 512Mb system suggest starting at:
-shared_buffers = 56MB
-# 1024Mb system suggest starting at:
-#shared_buffers = 160MB
-
-# effective_cache_size = 128MB
-# 512Mb system suggest starting at:
-effective_cache_size = 256MB
-# 1024Mb system suggest starting at:
-#effective_cache_size = 512MB
-
-#work_mem = 1MB
-# This is a per sort setting, so setting this too high with a high number of max_connections can be bad.
-# If the database load turns out to have a lot of sorting and not a lot of separate connections, you should increase this
-# and drop the max_connections.
-# 512Mb system suggest starting at:
-work_mem = 2MB
-# 1024Mb system suggest starting at:
-#work_mem = 4MB
-
-# As you get more memory in the system, moving this up can be quite useful if you notice vacuum processes taking forever.
-maintenance_work_mem = 16MB
-
-/etc/init.d/postgresql restart
 }}}