Changes between Version 20 and Version 21 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
09/19/10 18:06:48 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/PostgreSQL

    v20 v21  
    44
    55== Install PostgreSQL ==
     6{{{
     7apt-get install postgresql-8.4
     8}}}
     9
    610Enable automatic DB maintenance:
    711{{{
    812vim /etc/postgresql/8.4/main/postgresql.conf
     13# Enable remote access
     14listen_addresses = '*'
    915port = 5432
    1016track_counts = on
    1117autovacuum = on
    1218
     19vim /etc/postgresql/8.4/main/pg_hba.conf
     20host    all         all         my.ip.add.ress/24     md5
     21
    1322/etc/init.d/postgresql restart
     23
     24vim /etc/iptables.rules
     25-A INPUT -p tcp --dport 5432 -j ACCEPT
     26
     27reboot
    1428}}}
     29NB Don't do remote access as 'postgres' - to do so means can't simply access psql via 'su postgres'
    1530
    16 Install the Admin Pack for enhanced intrumentation:
    17 {{{
    18 apt-get install postgresql-contrib-8.4
    19 psql -d postgres -f /usr/share/postgresql/8.4/contrib/adminpack.sql
    20 }}}
    2131
    2232Adjust postgresql.conf for performance relative to resources available (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
     
    7181}}}
    7282
    73 Allow remote access:
     83(Optional) Install the Admin Pack for enhanced intrumentation:
    7484{{{
    75 passwd postgres
     85apt-get install postgresql-contrib-8.4
     86psql -d postgres -f /usr/share/postgresql/8.4/contrib/adminpack.sql
     87}}}
    7688
    77 vim /etc/postgresql/8.4/main/postgresql.conf
    78 listen_addresses = '*'
    79 
    80 vim /etc/postgresql/8.4/main/pg_hba.conf
    81 host    all         all         my.ip.add.ress/24     md5
    82 
    83 /etc/init.d/postgresql restart
    84 
    85 vim /etc/iptables.rules
    86 -A INPUT -p tcp --dport 5432 -j ACCEPT
    87 
    88 reboot
    89 }}}
    90 (Don't do remote access as 'postgres' - to do so means can't simply access psql via 'su postgres')
    91 
    92 It is possible to install [http://phppgadmin.sourceforge.net PHPPgAdmin] if you want a web-based management tool:
     89(Optional) Install [http://phppgadmin.sourceforge.net PHPPgAdmin] if you want a web-based management tool:
    9390{{{
    9491apt-get install phppgadmin
    9592}}}
    96 
    97  * [wiki:InstallationGuidelinesGISDataLinux#PostGIS]
    9893== Configure PostgreSQL for Sahana Eden ==
    9994{{{