Restrict pg_stat_statement_reset queries to PG12+ (CrunchyData#2418)

jkatz · web-flow · commit da556b9a0b2b · 2021-04-29T10:54:14.000-04:00
These are unavailable on older versions of PostgreSQL.

Issue: [ch11334]
diff --git a/bin/crunchy-postgres-exporter/start.sh b/bin/crunchy-postgres-exporter/start.sh
@@ -25,7 +25,6 @@ QUERIES=(
     queries_global
     queries_per_db
     queries_nodemx
-    queries_pg_stat_statements_reset
 )
 
 function trap_sigterm() {
@@ -175,6 +174,14 @@ else
         else
           echo_warn "Query file queries_pg_stat_statements.yml not loaded."
         fi
+        # queries_pg_stat_statements_reset is only available in PG12+. This may
+        # need to be updated based on a new path
+        if [[ -f ${CONFIG_DIR?}/queries_pg_stat_statements_reset.yml ]];
+        then
+          cat ${CONFIG_DIR?}/queries_pg_stat_statements_reset.yml >> /tmp/queries.yml
+        else
+          echo_warn "Query file queries_pg_stat_statements_reset.yml not loaded."
+        fi
     elif (( ${VERSION?} >= 130000 ))
     then
         if [[ -f ${CONFIG_DIR?}/pg13/queries_general.yml ]]
@@ -189,6 +196,14 @@ else
         else
           echo_warn "Query file queries_pg_stat_statements.yml not loaded."
         fi
+        # queries_pg_stat_statements_reset is only available in PG12+. This may
+        # need to be updated based on a new path
+        if [[ -f ${CONFIG_DIR?}/queries_pg_stat_statements_reset.yml ]];
+        then
+          cat ${CONFIG_DIR?}/queries_pg_stat_statements_reset.yml >> /tmp/queries.yml
+        else
+          echo_warn "Query file queries_pg_stat_statements_reset.yml not loaded."
+        fi
     else
         echo_err "Unknown or unsupported version of PostgreSQL.  Exiting.."
         exit 1
