Under installation settings you can view information about PostgreSQL status, version, etc. with few additional options as seen below:

Beside Execute options available, you can also view and modify parameters displayed under Configuration tab.

  • checkpoint_segments: Maximum number of log file segments between automatic WAL(Write-Ahead Log) checkpoints (each segment is normally 16 megabytes). The default is three segments. Increasing this parameter can increase the amount of time needed for crash recovery. This parameter can only be set in the postgresql.conf file or on the server command line.
  • datestyle: Specifies how dates are represented in the database. mdy stand for month, day and year respectively.
  • default_text_search_config: Specifies the name of the default configuration, which is the one used by text search functions if an explicit configuration parameter is omitted
  • lc_messages: Language of messages
  • lc_monetary: Formatting of currency amounts
  • lc_numeric: Formatting of numbers
  • lc_time: Formatting of dates and times
  • listen_addresses: Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications.
  • log_autovacuum_min_duration: Causes each action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs all autovacuum actions.
  • log_destination: PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set this parameter to a list of desired log destinations separated by commas. The default is to log to stderr. If csvlog is included in log_destination, log entries are output in "comma separated value" (CSV) format.
  • log_line_prefix: This is a printf-style string that is output at the beginning of each log line. % characters begin "escape sequences" that are replaced with status information as outlined below. Unrecognized escapes are ignored. Other characters are copied straight to the log line. %t prints out timestamp at the begining of each line %m prints timestamp with miliseconds, %u prints username,...
  • log_min_duration_statement: Causes the duration of each completed statement to be logged if the statement ran for at least the specified number of milliseconds. Setting this to zero prints all statement durations. Minus-one (the default) disables logging statement durations.
  • log_rotation_size: When logging_collector is enabled, this parameter determines the maximum size of an individual log file. After this many kilobytes have been emitted into a log file, a new log file will be created. Set to zero to disable size-based creation of new log files. This parameter can only be set in the postgresql.conf file or on the server command line.
  • log_timezone: Sets the time zone used for timestamps written in the server log.
  • logging_collector: This parameter enables the logging collector, which is a background process that captures log messages sent to stderr and redirects them into log files.
Tags: isl conference proxy, settings, configuration, postgresql

Was this article helpful?