...
- http://www.postgresql.org/docs/8.3/static/creating-cluster.html
- http://www.postgresql.org/docs/8.3/static/runtime-config-file-locations.html
- http://archives.postgresql.org/pgsql-admin/2007-05/msg00104.php
Security - Quick Start
This is my best guess on security and users - feel free to recommend alternatives.
For the time being, I have modified
- hba.conf
- postgresql.conf.
so as to allow the postgres user to connect to any database from any of
- localhost
- geoserver
- web server
This needs to be substantially refined for production.
The following section should address this in complete detail.
Performance Tuning
The EAS databases (mad, sfmaps) need to support 3 sorts of activities
...
Links
1 - http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm
2 - http://workshops.opengeo.org/postgis-intro/tuning.html
3 - http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
4 - http://postgis.refractions.net/docs/ch06.html
Security - Quick Start
This is my best guess on security and users - feel free to recommend alternatives.
For the time being, I have modified
- hba.conf
- postgresql.conf.
so as to allow the postgres user to connect to any database from any of
- localhost
- geoserver
- web server
This needs to be substantially refined for production.
The following section should address this in complete detail.
Security - Production
The dataserver should be accessible only from the following:
...