Changes between Version 4 and Version 5 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
09/18/10 12:12:42 (14 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • InstallationGuidelines/PostgreSQL

    v4 v5  
    11== Installation on PostgreSQL ==
    2 Replacing the simple SQLite database with PostgreSQL allows greater scalability & the ~~possibility~~ essential need of using PostGIS for spatial storage.
     2Replacing the simple SQLite database with [http://www.postgresql.org PostgreSQL] allows greater scalability & the possibility of [wiki:UserGuidelinesGISData#PostgreSQLmanagement using PostGIS for spatial storage].
    33
    44Suggest to use connection pools to reuse connections:
    … …  
    1616}}}
    1717
     18{{{
     19vim /etc/postgresql/8.3/main/postgresql.conf
     20track_counts = on
     21autovacuum = on
     22}}}
     23
     24Also see:
     25 * [wiki:InstallationGuidelinesGISDataLinux#PostGIS]
     26 * [wiki:UserGuidelinesGISData#PostgreSQLmanagement]
     27
     28{{{
     29su postgres
     30createuser -s -P sahana
     31
     32createdb -O sahana -E UTF8 sahana
     33}}}
     34
    1835A set of docs for setting up on Ubuntu: http://www.web2pyslices.com/main/slices/take_slice/14
    1936