4.4.4 Reference - Command Line Options

Table of Contents Previous Next



Use the --autostart_pgagent parameter to specify whether the installer should start the pgAgent service at boot-time. The default is yes.
Use the --autostart_pgbouncer parameter to specify whether the installer should start the PgBouncer service. The default is yes.
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.
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.
Use the --debuglevel parameter to set the level of detail written to the debug_log file (see --debugtrace). Higher values produce more detail (producing 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 installation troubleshooting details.
--disable-components component_list
Use the --disable-components parameter to specify a list of 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:
Linux and Windows only. The Postgres Enterprise Manager Client provides a powerful graphical interface for database management and monitoring.
Slony-I facilitates master-standby replication suited for large databases with a limited number of standby systems.
The --enable_acledit 1 option instructs the installer to grant permission to the user specified by the ‑‑serviceaccount option to access the 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. Note: Specification of this option is valid only when installing on Windows. This option cannot be specified when installing on Linux.
--enable-components component_list
Use the --enable-components parameter to specify a list of Advanced Server components to include in the installation. By default, all components are included in a standard Advanced Server. component_list is a comma-separated list containing one or more of the following components:
Linux and Windows only. The Postgres Enterprise Manager Client provides a powerful graphical interface for database management and monitoring.
Slony-I facilitates master-standby replication suited for large databases with a limited number of standby systems.
Include the --extract-only parameter to indicate that the installer should extract the Advanced Server binaries without performing a complete installation. Superuser privileges are not required for the --extract-only option. The default value is no.
Include the --help parameter to view a list of the optional parameters.
Use the --installer-language parameter to specify an installation language for 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.
Windows only. Include --install_runtimes to specify whether the installer should install the Microsoft Visual C++ runtime libraries. Default is yes.
--locale locale
Use the --mode parameter to specify an installation mode. The following modes are supported:
qt - Specify qt to tell the installer to use the Qt graphical toolkit
gtk - Specify gtk to tell the installer to use the GTK graphical toolkit.
xwindow - Specify xwindow to tell the installer to use the X Window graphical toolkit.
text - Specify text to perform a text mode installation in a console window. This is a Linux-only option.
unattended - Specify unattended to specify that the installer should perform an installation that requires no user input during the installation process.
--optionfile config_파일
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.
Use the --pgbouncerport parameter to specify a listener port for the PgBouncer service. The default value is 6432.
--prefix installation_dir
Use the --prefix parameter to specify an installation directory for Advanced Server. The default installation directory on a Linux system is:
--productkey product_key
Use the --productkey parameter to specify a value for the product key.
The --productkey parameter is only required when the specified system locale is Japanese, Chinese or Korean.
--serverport port_number
Use the --serverport parameter to specify a listener port number for Advanced Server.
If you are installing Advanced Server in unattended mode, and do not specify a value using the --serverport parameter, the installer will use port 5444, or the first available port after port 5444 as the default listener port.
Use the --server_utilization parameter to specify a value for the edb_dynatune configuration parameter. The edb_dynatune configuration parameter determines how 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.
A value of 100 is appropriate for a host machine that is dedicated to running 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. 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 set to postgresql, the default value of ‑‑serviceaccount is set to postgres.
Please note that 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 will use the same service account, thereby having the required permissions to access the Advanced Server binaries and data directory. Note: Specification of the --enable_acledit option is permitted only when installing on Windows. The --enable_acledit option cannot be specified when installing on Linux.
Please note that if you do not include the --serviceaccount option when invoking the installer, the NetworkService account will own the database service, and the pgAgent service will be owned by either enterprisedb or postgres (depending on the installation mode).
--servicename service_name
Use the --servicename parameter to specify the name of the Advanced Server service. The default is ppas-9.5.
--servicepassword user_password
Windows only. 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.
Use the --unattendedmodeui parameter to specify the installer's behavior during an unattended installation.
Include --unattendedmodeui none to specify that the installer should not display progress bars during the 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).
Include the --version parameter to retrieve version information about the installer:
--webusername {registered_username}
You must specify the name of a registered user and password when performing an installation of EDB Postgres Advanced Server 9.5. Use the --webusername parameter to specify the name of the registered EnterpriseDB user that is performing the installation.
registered_username must be an email address.
--webpassword {associated_password}
Use the --webpassword parameter to specify the password associated with the registered EnterpriseDB user that is performing the installation.
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 Advanced Server installation will be used to process heavy online transaction processing workloads.
Specify mixed if Advanced Server will provide a mix of transaction processing and data reporting.
Specify reporting if Advanced Server will be 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. 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 (Postgres Plus) Migration Guide, available at:
--xlogdir directory_name
Linux only. Use the --xlogdir parameter to specify a location for the write-ahead log. The default value is datadir/pg_xlog.


Table of Contents Previous Next