<commit_before>--- a/diags.raw	2020-10-06 18:26:16.732431803 +0000
+++ b/diags.raw	2020-10-06 18:26:22.827311994 +0000
@@ -98,7 +98,7 @@
 
 section "New Tasks by Hour Added"
 
-postgresql-load <<EOF
+su -l -c psql postgres <<EOF
 \c pscheduler
 SELECT
     date_trunc('hour', added) AS hour,
@@ -113,7 +113,7 @@
 
 section "New Runs by Hour Added"
 
-postgresql-load <<EOF
+su -l -c psql postgres <<EOF
 \c pscheduler
 SELECT
     date_trunc('hour', added) AS hour,
@@ -128,7 +128,7 @@
 
 section "Run States by Hour"
 
-postgresql-load <<EOF
+su -l -c psql postgres <<EOF
 \c pscheduler
 SELECT
     run_state.enum AS state,
@@ -187,7 +187,7 @@
 fi
 
 section "HTTPD Error Log (Last ${LOG_LIMIT} Lines)"
-LOG="/var/log/httpd/error_log"
+LOG="/var/log/apache2/error.log"
 if [ -r "${LOG}" ]
 then
     tail "-${LOG_LIMIT}" "${LOG}"
@@ -198,17 +198,11 @@
 
 section "PostgreSQL Log (Last ${LOG_LIMIT} Lines)"
 
-PG_DATA=$(postgresql-load <<EOF
-\\t
-\\a
-SELECT setting FROM pg_settings WHERE name = 'data_directory';
-EOF
-)
-PG_LOG="${PG_DATA}/pg_log"
+PG_LOG="/var/log/postgresql"
 
 if [ -d "${PG_LOG}" ]
 then
-    ls -rtd ${PG_DATA}/pg_log/* | xargs cat | tail "-${LOG_LIMIT}"
+    ls -rtd ${PG_LOG}/*.log | xargs cat | tail "-${LOG_LIMIT}"
 else
     echo "PostgreSQL logs not found in ${PG_LOG}"
 fi<commit_msg>Refreshing Debian quilt patch to latest changes.<commit_after>--- pscheduler-core.orig/diags.raw	2020-10-22 14:31:09.493840421 +0000
+++ pscheduler-core/diags.raw	2020-10-22 14:34:49.475104925 +0000
@@ -119,7 +119,7 @@
 
 section "New Tasks by Hour Added"
 
-postgresql-load <<EOF
+su -l -c psql postgres <<EOF
 \c pscheduler
 SELECT
 date_trunc('hour', added) AS hour,
@@ -134,7 +134,7 @@
 
 section "New Runs by Hour Added"
 
-postgresql-load <<EOF
+su -l -c psql postgres <<EOF
 \c pscheduler
 SELECT
 date_trunc('hour', added) AS hour,
@@ -149,7 +149,7 @@
 
 section "Run States by Hour"
 
-postgresql-load <<EOF
+su -l -c psql postgres <<EOF
 \c pscheduler
 SELECT
 run_state.enum AS state,
@@ -208,7 +208,7 @@
 fi
 
 section "HTTPD Error Log (Last ${LOG_LIMIT} Lines)"
-LOG="/var/log/httpd/error_log"
+LOG="/var/log/apache2/error.log"
 if [ -r "${LOG}" ]
 then
     tail "-${LOG_LIMIT}" "${LOG}"
@@ -219,17 +219,11 @@
 
 section "PostgreSQL Log (Last ${LOG_LIMIT} Lines)"
 
-PG_DATA=$(postgresql-load <<EOF
-\\t
-\\a
-SELECT setting FROM pg_settings WHERE name = 'data_directory';
-EOF
-)
-PG_LOG="${PG_DATA}/pg_log"
+PG_LOG="/var/log/postgresql"
 
 if [ -d "${PG_LOG}" ]
 then
-    ls -rtd ${PG_DATA}/pg_log/* | xargs cat | tail "-${LOG_LIMIT}"
+    ls -rtd ${PG_LOG}/*.log | xargs cat | tail "-${LOG_LIMIT}"
 else
     echo "PostgreSQL logs not found in ${PG_LOG}"
 fi
{'fraction_non_alphanumeric': 0.18411284335560504, 'fraction_numerical': 0.07126948775055679, 'mean_word_length': 3.396411092985318, 'pattern_counts': {'":': 0, '<': 31, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1690631', 'n_tokens_mistral': 1226, 'n_tokens_neox': 1063, 'n_words': 293}