Update the validation template for postgresql

Add some configuration options on valuation rules file,
these options are availables from the release 9.5 and 9.6

New options from 9.5:
 - gin_pending_list_limit
 - idle_in_transaction_session_timeout
Changelog:
https://www.postgresql.org/docs/10/static/release-9-5.html

New options from 9.6:
 - log_min_duration_statement
 - backend_flush_after
 - bgwriter_flush_after
 - checkpoint_flush_after
 - force_parallel_mode
 - parallel_setup_cost
 - parallel_tuple_cost
 - replacement_sort_tuples
Changelog:
https://www.postgresql.org/docs/10/static/release-9-6.html

Closes-bug: #1745238
Change-Id: I89d793ccc7fa43deb3c1da7b23ce10cdf1e85c4d

1 files changed, 48 insertions, 0 deletions

diff --git a/trove/templates/postgresql/validation-rules.json b/trove/templates/postgresql/validation-rules.json
index 35b5fd5d..9af858c2 100644
--- a/trove/templates/postgresql/validation-rules.json
+++ b/trove/templates/postgresql/validation-rules.json
@@ -890,7 +890,55 @@
         {
             "name": "log_min_duration_statement",
             "restart_required": false,
+            "min": -1,
+            "type": "integer"
+        },
+        {
+            "name": "backend_flush_after",
+            "restart_required": false,
             "type": "string"
+        },
+        {
+            "name": "bgwriter_flush_after",
+            "restart_required": false,
+            "type": "string"
+        },
+        {
+            "name": "checkpoint_flush_after",
+            "restart_required": false,
+            "type": "string"
+        },
+        {
+            "name": "force_parallel_mode",
+            "restart_required": false,
+            "type": "boolean"
+        },
+        {
+            "name": "parallel_setup_cost",
+            "restart_required": false,
+            "type": "float"
+        },
+        {
+            "name": "parallel_tuple_cost",
+            "restart_required": false,
+            "type": "float"
+        },
+        {
+            "name": "gin_pending_list_limit",
+            "restart_required": false,
+            "type": "string"
+        },
+        {
+            "name": "idle_in_transaction_session_timeout",
+            "restart_required": false,
+            "min": 0,
+            "type": "integer"
+        },
+        {
+            "name": "replacement_sort_tuples",
+            "restart_required": false,
+            "min": 0,
+            "type": "integer"
         }
     ]
 }