wiki:InstallationGuidelines/PostgreSQL

Version 5 (modified by Fran Boon, 11 years ago) ( diff )

--

Installation on PostgreSQL

Replacing the simple SQLite database with PostgreSQL allows greater scalability & the possibility of using PostGIS for spatial storage.

Suggest to use connection pools to reuse connections:

db=SQLDB('postgres://user:password@hostname/db',pools=20)

How many pools?

whatever you choose it always starts with one and grows with the
number of concurrent requests up to the value of pools (the max number
of concurrent pools). So pools should be the max number of concurrent
requests you expect. That is the max value of:
<number of requests/second> / <average time per request in seconcds> 
vim /etc/postgresql/8.3/main/postgresql.conf
track_counts = on
autovacuum = on

Also see:

su postgres
createuser -s -P sahana

createdb -O sahana -E UTF8 sahana

A set of docs for setting up on Ubuntu: http://www.web2pyslices.com/main/slices/take_slice/14


InstallationGuidelines

Note: See TracWiki for help on using the wiki.