Changes between Version 20 and Version 21 of InstallationGuidelines/PostgreSQL

Timestamp:

09/19/10 18:06:48 (14 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -4 +4 @@
 
 == Install PostgreSQL ==
+{{{
+apt-get install postgresql-8.4
+}}}
+
 Enable automatic DB maintenance:
 {{{
 vim /etc/postgresql/8.4/main/postgresql.conf
+# Enable remote access
+listen_addresses = '*'
 port = 5432
 track_counts = on
 autovacuum = on
 
+vim /etc/postgresql/8.4/main/pg_hba.conf
+host    all         all         my.ip.add.ress/24     md5
+
 /etc/init.d/postgresql restart
+
+vim /etc/iptables.rules
+-A INPUT -p tcp --dport 5432 -j ACCEPT
+
+reboot
 }}}
+NB Don't do remote access as 'postgres' - to do so means can't simply access psql via 'su postgres'
 
-Install the Admin Pack for enhanced intrumentation:
-{{{
-apt-get install postgresql-contrib-8.4
-psql -d postgres -f /usr/share/postgresql/8.4/contrib/adminpack.sql
-}}}
 
 Adjust postgresql.conf for performance relative to resources available (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
@@ -71 +81 @@
 }}}
 
-Allow remote access:
+(Optional) Install the Admin Pack for enhanced intrumentation:
 {{{
-passwd postgres
+apt-get install postgresql-contrib-8.4
+psql -d postgres -f /usr/share/postgresql/8.4/contrib/adminpack.sql
+}}}
 
-vim /etc/postgresql/8.4/main/postgresql.conf
-listen_addresses = '*'
-
-vim /etc/postgresql/8.4/main/pg_hba.conf
-host    all         all         my.ip.add.ress/24     md5
-
-/etc/init.d/postgresql restart
-
-vim /etc/iptables.rules
--A INPUT -p tcp --dport 5432 -j ACCEPT
-
-reboot
-}}}
-(Don't do remote access as 'postgres' - to do so means can't simply access psql via 'su postgres')
-
-It is possible to install [http://phppgadmin.sourceforge.net PHPPgAdmin] if you want a web-based management tool:
+(Optional) Install [http://phppgadmin.sourceforge.net PHPPgAdmin] if you want a web-based management tool:
 {{{
 apt-get install phppgadmin
 }}}
-
- * [wiki:InstallationGuidelinesGISDataLinux#PostGIS]
 == Configure PostgreSQL for Sahana Eden ==
 {{{