Changes between Version 24 and Version 25 of sysadminiptables

Timestamp:

Jun 24, 2009, 11:35:55 AM (14 years ago)

Author:

risard

Comment:

--

sysadminiptables

@@ -313 +313 @@
 }}}
 
-
-
-
+== Special Postgresql Issues ==
+
+=== Allowing Remote Connections ===
+{{{
+    sudo vim /etc/postgresql/8.3/main/postgresql.conf
+    #listen_addresses = ‘localhost’
+#to     
+    listen_addresses = ‘<ip address of oils server>’
+
+    sudo vim /etc/postgresql/8.3/main/pg_hba.conf
+#edit pg_hba.conf to reflect file snippet at and of section
+
+#restart
+    su postgres
+    pg_ctl restart -D /data/postgresql/8.3/main -l /<path_to_log_file>/<my_logfile>     
+                
+}}}
+
+=== Installing JSON::XS ===
+
+{{{
+    which gcc
+
+#If you don't, install one:
+
+    apt-get update
+    apt-get install gcc
+
+    perl -MCPAN -e 'CPAN::Shell?install(“JSON::XS”)'
+}}}
+
+
+