Appendix A Parameters

This appendix describes the parameters to be set in the postgresql.conf file of Symfoware Server.

The postgresql.conf file is located in the data storage destination.

core_directory (string)
This parameter specifies the directory where the corefile is to be output. If this parameter is omitted, the data storage destination is used by default. This parameter can only be set when specified on starting an instance. It cannot be changed dynamically, while an instance is active.
core_contents (string)
This parameter specifies the contents to be included in the corefile.
- full: Outputs all contents of the server process memory to the corefile.
- none: Does not output a corefile.
- minimum: Outputs only non-shared memory server processes to the corefile. This reduces the size of the corefile. However, in some cases, this file may not contain sufficient information for examining the factor that caused the corefile to be output.
If this parameter is omitted, "minimum" is used by default. This parameter can only be set when specified on starting an instance. It cannot be changed dynamically, while an instance is active.
keystore_location (string)
This parameter specifies the directory that stores the keystore file. Specify a different location from other database clusters. This parameter can only be set when specified on starting an instance. It cannot be changed dynamically, while an instance is active.
tablespace_encryption_algorithm (string)
This parameter specifies the encryption algorithm for tablespaces that will be created. Valid values are AES128, AES256, and none. If you specify "none", encryption is not performed. The default value is "none". To perform encryption, it is recommended that you specify AES256. Only superusers can change this setting.
backup_destination (string)
This parameter specifies the absolute path of the directory where pgx_dmpall will store the backup data. Specify a different location from other database clusters. This parameter can only be set when specified on starting an instance. It cannot be changed dynamically, while an instance is active.
Place this directory on a different disk from the data directory to be backed up and the tablespace directory. Ensure that users do not store arbitrary files in this directory, because the contents of this directory are managed by the database system.
search_path (string)
When using the SUBSTR function compatible with Oracle databases, set "oracle" and "pg_catalog" in the search_path parameter. You must specify "oracle" before "pg_catalog".
Example
```
search_path = '"$user", public, oracle, pg_catalog'
```
Information
- The search_path feature specifies the priority of the schema search path. The SUBSTR function in Oracle database is defined in the oracle schema.
- Refer to "Statement Behavior" under "Server Administration" in the PostgreSQL Documentation for information on search_path.
track_waits (string)
This parameter enables collection of statistics for pgx_stat_lwlock and pgx_stat_latch.
- on: Enables collection of statistics.
- off: Disables collection of statistics.
If this parameter is omitted, "on" is assumed.
Only superusers can change this setting.
track_sql (string)
This parameter enables collection of statistics for pgx_stat_sql.
- on: Enables collection of statistics.
- off: Disables collection of statistics.
If this parameter is omitted, "on" is assumed.
Only superusers can change this setting.

Note

Note the following when specifying the path:

Specify \\ as the path delimiter.
Enclose the path in double quotes (") if it contains spaces.

See

Refer to "Server Configuration" under "Server Administration" in the PostgreSQL Documentation for information on other postgresql.conf parameters.