1 files changed, 59 insertions, 19 deletions

diff --git a/www/hs-postgrest/files/default.conf.in b/www/hs-postgrest/files/default.conf.in
index 9a39f70e4d91..38840f02d22b 100644
--- a/www/hs-postgrest/files/default.conf.in
+++ b/www/hs-postgrest/files/default.conf.in
@@ -1,42 +1,82 @@
+### REQUIRED:
 db-uri = "postgres://user:pass@localhost:5432/dbname"
-db-schema = "public" # this schema gets added to the search_path of every request
+db-schemas = "public"
 db-anon-role = "postgres"
+
+### OPTIONAL:
+## number of open connections in the pool
 db-pool = 10
+
+## Time to live, in seconds, for an idle database pool connection.
 db-pool-timeout = 10
 
+## extra schemas to add to the search_path of every request
+# db-extra-search-path = "public"
+
+## limit rows in response
+# db-max-rows = 1000
+
+## stored proc to exec immediately after auth
+# db-pre-request = "stored_proc_name"
+
+## stored proc that overrides the root "/" spec
+## it must be inside the db-schema
+# db-root-spec = "stored_proc_name"
+
+## Notification channel for reloading the schema cache
+db-channel = "pgrst"
+
+## Enable or disable the notification channel
+db-channel-enabled = true
+
+## Enable in-database configuration
+db-config = true
+
+## how to terminate database transactions
+## possible values are:
+## commit (default)
+##   transaction is always committed, this can not be overriden
+## commit-allow-override
+##   transaction is committed, but can be overriden with Prefer tx=rollback header
+## rollback
+##   transaction is always rolled back, this can not be overriden
+## rollback-allow-override
+##   transaction is rolled back, but can be overriden with Prefer tx=commit header
+db-tx-end = "commit"
+
+## enable or disable prepared statements. disabling is only necessary when behind a connection pooler.
+## when disabled, statements will be parametrized but won't be prepared.
+db-prepared-statements = true
+
 server-host = "127.0.0.1"
 server-port = 3000
 
 ## unix socket location
 ## if specified it takes precedence over server-port
 # server-unix-socket = "/tmp/pgrst.sock"
+
 ## unix socket file mode
+## when none is provided, 660 is applied by default
 # server-unix-socket-mode = "660"
 
-## base url for swagger output
-# server-proxy-uri = ""
+## determine if the OpenAPI output should follow or ignore role privileges or be disabled entirely
+## admitted values: follow-privileges, ignore-privileges, disabled
+openapi-mode = "follow-privileges"
+
+## base url for the OpenAPI output
+# openapi-server-proxy-uri = ""
 
 ## choose a secret, JSON Web Key (or set) to enable JWT auth
 ## (use "@filename" to load from separate file)
-# jwt-secret = "foo"
-# secret-is-base64 = false
+# jwt-secret = "secret_with_at_least_32_characters"
 # jwt-aud = "your_audience_claim"
-
-## limit rows in response
-# max-rows = 1000
-
-## stored proc to exec immediately after auth
-# pre-request = "stored_proc_name"
+jwt-secret-is-base64 = false
 
 ## jspath to the role claim key
-# role-claim-key = ".role"
-
-## extra schemas to add to the search_path of every request
-# db-extra-search-path = "extensions, util"
-
-## stored proc that overrides the root "/" spec
-## it must be inside the db-schema
-# root-spec = "stored_proc_name"
+# jwt-role-claim-key = ".role"
 
 ## content types to produce raw output
 # raw-media-types="image/png, image/jpg"
+
+## logging level, the admitted values are: crit, error, warn and info.
+log-level = "error"