8.3.15. PostgreSQL settings

Attention!

Changing the settings requires restarting the instance.

PostgreSQL instance settings are managed in the "PostgreSQL" section on the "Settings" tab:

The following settings can be changed:

  • max_connections — maximum number of simultaneous connections to the database server (default is 100).
  • Time zone — time zone for displaying and interpreting timestamps (default is Europe/Kyiv).
  • Date format — specification of the date and time output format and input/output specification for the year/month/day order (default is iso, mdy).
  • cron.database_name — name of the database for which the pg_cron extension will be enabled.
  • shared_preload_libraries — libraries that must be preloaded when the database server starts.
    • Used for libraries that need to perform certain operations that can only be carried out when the server starts (e.g., allocating shared memory, launching background processes, etc.).
    • It is recommended to include only the necessary libraries. Preloading can reduce the startup time of a library when it is first used, but it may increase the startup time of each new process, even if that process does not use the library.
    • pg_stat_statements, pg_textsearch, pg_prewarm are available only for PostgreSQL 17+.
Inhalt