postgresql.conf

By default postgresql-server stores its configuration in /pg_data1/postgresql.conf ($PGDATA/postgresql.conf).

Here are several parameters you could configure with ADCM bundle. It is possible to set in ADPG configurations, which will be written in the postgresql.conf file.

NOTE

Changed parameter values are applied only after Reconfigure & Reload or Reconfigure & Restart.

Resource parameters

Parameter name Description Default value

listen_addresses

Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications. Change requires restart

localhost

port

The TCP port the server listens on. Change requires restart

5432

max_connections

Determines the maximum number of concurrent connections to the database server. Change requires restart

100

shared_buffers

Sets the amount of memory the database server used for the shared memory buffer. A reasonable starting value for shared_buffers is 25% of the memory in your system. The value is specified in MB. Change requires restart

128

max_worker_processes

Sets the maximum number of background processes that the system can support. Change requires restart

8

max_parallel_workers

Sets the maximum number of workers that the system can support for parallel operations. Change requires restart

8

max_parallel_workers_per_gather

Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. Change requires restart

2

max_parallel_maintenance_workers

Sets the maximum number of parallel workers that can be started by a single utility command. Change requires restart

2

Logging parameters

Parameter name Description Default value

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

true

log_directory

Directory, where log files are written can be absolute or relative to PGDATA

log

log_filename

Log file name pattern can include strftime() exceptions

postgresql-%a.log

log_rotation_age

Automatic rotation of logfiles will happen after that time. 0 disables

1d

log_rotation_size

Automatic rotation of logfiles will happen after that much log output. 0 disables

0

log_min_messages

Minimum log level of messages to trace

warning

log_min_error_statement

Controls which SQL statements causing an error condition are recorded in the server log

error

Custom settings

When you activate advanced settings in the ADPG configurations section, a multi-line edit box becomes available: postgresql.conf custom section. In this edit box you can enter any PostgreSQL parameter.

Parameters are written to the postgresql.conf file in the following order:

  1. Parameters from postgresql.conf custom section.

  2. Resource parameters and Logging parameters.

NOTE

Parameters from postgresql.conf custom section have lower priority than other parameters.

Validation of parameters from postgresql.conf custom section is not used in ADCM. Changes in postgresql.conf file will be reverted if Start action of ADPG service fails.

Found a mistake? Seleсt text and press Ctrl+Enter to report it