pgrest.toml

### REQUIRED:
db-uri = "postgres://starboy:ot8xosk8czcikGFpFByF@localhost:5434/lego_castle"
db-schema = "public"
db-anon-role = "anon"

# ### 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

# ## Determine if GUC request settings for headers, cookies and jwt claims use the legacy names (string with dashes, invalid starting from PostgreSQL v14) with text values instead of the new names (string without dashes, valid on all PostgreSQL versions) with json values.
# ## For PostgreSQL v14 and up, this setting will be ignored.
# db-use-legacy-gucs = 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 = "!4"
# 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"

# ## 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 = "secret_with_at_least_32_characters"
# # jwt-aud = "your_audience_claim"
# jwt-secret-is-base64 = false

# ## jspath to the role claim key
# 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"