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 |
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 |
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 |
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:
-
Parameters from postgresql.conf custom section.
|
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.