Changes between Version 55 and Version 56 of InstallationGuidelines/PostgreSQL

Timestamp:

11/15/11 16:23:01 (13 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -261 +261 @@
  * http://www.revsys.com/writings/postgresql-performance.html
  * http://www.postgresql.org/docs/8.4/static/runtime-config-logging.html
+
+Log all queries which take longer than 5s:
+{{{
+vim /etc/rsyslog.conf
+local0.*    /var/log/postgresql.log
+
+/etc/init.d/rsyslogd restart
+
+vim /etc/postgresql/8.4/main/postgresql.conf
+log_destination = 'syslog'
+syslog_facility = 'LOCAL0'
+syslog_ident = 'postgres'
+log_min_duration_statement = 5000
+
+/etc/init.d/postgresql restart
+
+tail -n 45 -f /var/log/postgresql.log
+}}}
+
+Disable logging again:
+{{{
+vim /etc/postgresql/8.4/main/postgresql.conf
+log_min_duration_statement = -1
+
+/etc/init.d/postgresql restart
+}}}
+
+
+Log all queries which take longer than 5s & do an 'EXPLAIN' on those queries (not working)
  * http://www.depesz.com/index.php/2008/11/23/waiting-for-84-auto-explain/
-
-Log all queries which take longer than 5s:
-{{{
-su postgres
-psql
-set log_min_duration_statement = 5000;
-\q
-
-tail -n 45 -f /var/log/postgresql/postgresql-8.4-main.log
-}}}
-
-Disable logging again:
-{{{
-su postgres
-psql
-set log_min_duration_statement = -1;
-\q
-}}}
-
-Log all queries which take longer than 5s & do an 'EXPLAIN' on those queries (not working)
 {{{
 LOAD 'auto_explain';