Reference: Command line options v14

You can optionally include the following parameters for an EDB Postgres Advanced Server installation on the command line, or in a configuration file when invoking the EDB Postgres Advanced Server installer.

--create_samples { yes | no }

Use the --create_samples option to specify whether the installer should create the sample tables and procedures for the database dialect specified with the --databasemode parameter. The default is yes.

--databasemode { oracle | postgresql }

Use the --databasemode parameter to specify a database dialect. The default is oracle.

--datadir data_directory

Use the --datadir parameter to specify a location for the cluster's data directory. data_directory is the name of the directory; include the complete path to the desired directory.

--debuglevel { 0 | 1 | 2 | 3 | 4 }

Use the --debuglevel parameter to set the level of detail written to the debug_log file (see --debugtrace). Higher values produce more detail in a longer trace file. The default is 2.

--debugtrace debug_log

Use the --debugtrace parameter to troubleshoot installation problems. debug_log is the name of the file that contains troubleshooting details.

--disable-components component_list

Use the --disable-components parameter to specify a list of EDB Postgres Advanced Server components to exclude from the installation. By default, component_list contains '' (the empty string). component_list is a comma-separated list containing one or more of the following components:

dbserver

EDB Postgres Advanced Server 14.

pgadmin4

The EDB Postgres pgAdmin 4 provides a powerful graphical interface for database management and monitoring.

--enable_acledit { 1 | 0 }

The --enable_acledit 1 option instructs the installer to grant permission to the user specified by the --serviceaccount option to access the EDB Postgres Advanced Server binaries and data directory. By default, this option is disabled if --enable_acledit 0 is specified or if the --enable_acledit option is completely omitted.

In order to perform future operations such as upgrading EDB Postgres Advanced Server, access to the data directory must exist for the service account user specified by the --serviceaccount option. By specifying the --enable_acledit 1 option, access to the data directory by the service account user is provided.

--enable-components component_list

Although this option is listed when you run the installer with the --help option, the --enable-components parameter has absolutely no effect on which components are installed. All components are installed regardless of what is specified in component_list. In order to install only specific selected components, you must use the --disable-components parameter previously described in this section to list the components you don't want to install.

--extract-only { yes | no }

Include the --extract-only parameter to indicate that the installer should extract the EDB Postgres Advanced Server binaries without performing a complete installation. Superuser privileges are not required for the --extract-only option. The default value is no.

--help

Include the --help parameter to view a list of the optional parameters.

--installer-language { en | ja | zh_CN | zh_TW | ko }

Use the --installer-language parameter to specify an installation language for EDB Postgres Advanced Server. The default is en.

en specifies English.

ja specifies Japanese

zh_CN specifies Chinese Simplified.

zh_TW specifies Traditional Chinese.

ko specifies Korean.

--install_runtimes { yes | no }

Include --install_runtimes to specify whether the installer should install the Microsoft Visual C++ runtime libraries. Default is yes.

--locale locale

Specifies the locale for the EDB Postgres Advanced Server cluster. By default, the installer uses the locale detected by initdb.

--mode { unattended }

Use the --mode unattended parameter to specify that the installer should perform an installation that requires no user input during the installation process.

--optionfile config_file

Use the --optionfile parameter to specify the name of a file that contains the installation configuration parameters. config_file must specify the complete path to the configuration parameter file.

--prefix installation_dir/as14

Use the --prefix parameter to specify an installation directory for EDB Postgres Advanced Server. The installer appends a version-specific sub-directory (that is, as14) to the specified directory. The default installation directory is:

C:\Program Files\edb\as14

--serverport port_number

Use the --serverport parameter to specify a listener port number for EDB Postgres Advanced Server.

If you are installing EDB Postgres Advanced Server in unattended mode, and don't specify a value using the --serverport parameter, the installer uses port 5444, or the first available port after port 5444 as the default listener port.

--server_utilization {33 | 66 | 100}

Use the --server_utilization parameter to specify a value for the edb_dynatune configuration parameter. The edb_dynatune configuration parameter determines how EDB Postgres Advanced Server allocates system resources.

• A value of 33 is appropriate for a system used for development. A low value dedicates the least amount of the host machine’s resources to the database server.
• A value of 66 is appropriate for an application server with a fixed number of applications. A mid-range value dedicates a moderate amount of system resources to the database server. The default value is 66.
• A value of 100 is appropriate for a host machine that is dedicated to running EDB Postgres Advanced Server. A high value dedicates most of the system resources to the database server.

When the installation is complete, you can adjust the value of edb_dynatune by editing the postgresql.conf file, located in the data directory of your EDB Postgres Advanced Server installation. After editing the postgresql.conf file, you must restart the server for the changes to take effect.

--serviceaccount user_account_name

Use the --serviceaccount parameter to specify the name of the user account that owns the server process.

• If --databasemode is set to oracle (the default), the default value of --serviceaccount is enterprisedb.
• If --databasemode is postgresql, the default value of --serviceaccount is set to postgres.

For security reasons, the --serviceaccount parameter must specify the name of an account that does not hold administrator privileges.

If you specify both the --serviceaccount option and the --enable_acledit 1 option when invoking the installer, the database service and pgAgent uses the same service account, thereby having the required permissions to access the EDB Postgres Advanced Server binaries and data directory.

--servicename service_name

Use the --servicename parameter to specify the name of the EDB Postgres Advanced Server service. The default is edb-as-14.

--servicepassword user_password

Use --servicepassword to specify the OS system password. If unspecified, the value of --servicepassword defaults to the value of --superpassword.

--superaccount super_user_name

Use the --superaccount parameter to specify the user name of the database superuser.

• If --databasemode is set to oracle (the default), the default value of --superaccount is enterprisedb.
• If --databasemode is set to postgresql, the default value of --superaccount is set to postgres.

--superpassword superuser_password

Use --superpassword to specify the database superuser password. If you are installing in non-interactive mode, --superpassword defaults to enterprisedb.

--unattendedmodeui { none | minimal | minimalWithDialogs }

Use the --unattendedmodeui parameter to specify installer behavior during an unattended installation.

Include --unattendedmodeui none to specify that the installer should not display progress bars during the EDB Postgres Advanced Server installation.

Include --unattendedmodeui minimal to specify that the installer should display progress bars during the installation process. This is the default behavior.

Include --unattendedmodeui minimalWithDialogs to specify that the installer should display progress bars and report any errors encountered during the installation process (in additional dialogs).

--version

Include the --version parameter to retrieve version information about the installer:

EDB Postgres Advanced Server 14.0.3-1 --- Built on 2020-10-23 00:12:44 IB: 20.6.0-202008110127

--workload_profile {oltp | mixed | reporting}

Use the --workload_profile parameter to specify an initial value for the edb_dynatune_profile configuration parameter. edb_dynatune_profile controls aspects of performance-tuning based on the type of work that the server performs.

• Specify oltp if the EDB Postgres Advanced Server installation is used to support heavy online transaction processing workloads.
• The default value is oltp.
• Specify mixed if EDB Postgres Advanced Server provides a mix of transaction processing and data reporting.
• Specify reporting if EDB Postgres Advanced Server is used for heavy data reporting.

After the installation is complete, you can adjust the value of edb_dynatune_profile by editing the postgresql.conf file, located in the data directory of your EDB Postgres Advanced Server installation. After editing the postgresql.conf file, you must restart the server for the changes to take effect.

For more information about edb_dynatune and other performance-related topics, see the EDB Postgres Advanced Server Guide available at:

https://www.enterprisedb.com/docs