PostGIS tips - Use at your own risk!

pgis_tips.txt

Database machine

    Install postgres and postgis
    make sure you can log on via md5 in pg_hba.conf
    check listen addresses in postgresql.conf
    set kernel parameters in sysctl.conf to allow for larger shared memory - http://www.postgresql.org/docs/8.3/static/kernel-resources.html

  kernel.shmmax=2684354560
  kernel.shmall=2097152

    You may also want to set Memory Overcommit to 2. Even machines with a lot of memory sometimes kill postgres by overcommitting virtual memory.

    vm.overcommit_memory=2

    set shared_buffers to 25% of total memory
    set effective_cache_size to 50% of total memory