Installing Advanced Server with the Interactive Installer v10

You can use the Advanced Server interactive installer to install Advanced Server on Windows. The interactive installer is available from the EnterpriseDB website at:

https://www.enterprisedb.com/advanced-downloads

You can invoke the graphical installer in different installation modes to perform an Advanced Server installation:

During the installation, the graphical installer copies a number of temporary files to the location specified by the TEMP environment variable. You can optionally specify an alternate location for the temporary files by modifying or creating the TEMP environment variable.

If invoking the installer from the command line, you can set the value of the variable on the command line. Use the command:

SET TEMP=temp_file_location

Where temp_file_location specifies the alternate location for the temporary files and must match the permissions with the TEMP environment variable.

Note

If you are invoking the installer to perform a system upgrade, the installer will preserve the configuration options specified during the previous installation.

Setting Cluster Preferences during a Graphical Installation

During an installation, the graphical installer invokes the PostgreSQL initdb utility to initialize a cluster. If you are using the graphical installer, you can use the INITDBOPTS environment variable to specify your initdb preferences. Before invoking the graphical installer, set the value of INITDBOPTS at the command line, specifying one or more cluster options. For example:

SET INITDBOPTS= -k -E=UTF-8

If you specify values in INITDBOPTS that are also provided by the installer (such as the –D option, which specifies the installation directory), the value specified in the graphical installer will supersede the value if specified in INITDBOPTS.

For more information about using initdb cluster configuration options, see the PostgreSQL Core Documentation available at:

https://www.postgresql.org/docs/10/static/app-initdb.html

In addition to the cluster configuration options documented in the PostgreSQL core documentation, Advanced Server supports the following initdb options:

--no-redwood-compat

--no-redwood-compat instructs the server to create the cluster in PostgreSQL mode. When the cluster is created in PostgreSQL mode, the name of the database superuser is postgres and the name of the default database is postgres. A small subset of Advanced Server features compatible with Oracle databases are available with this mode. However, we recommend using the Advanced Server in redwood compatibility mode to have access to all its Oracle compatibility features.

--redwood-like

--redwood-like instructs the server to use an escape character (an empty string ('')) following the LIKE (or PostgreSQL compatible ILIKE) operator in a SQL statement that is compatible with Oracle syntax.

--icu-short-form

--icu-short-form creates a cluster that uses a default ICU (International Components for Unicode) collation for all databases in the cluster. For more information about Unicode collations, see Basic Unicode collation algorithm concepts.

Locales Requiring Product Keys

The Advanced Server 10 installer will request a product key before completing an installation into a host system using one of the locales listed in the table below. Product keys are available from your local Advanced Server distributor.

Note

The product key applies only to the Advanced Server installation program. The Advanced Server database program has no built-in limitations or expiration features that require a product key or any other activation technique.

LocaleLocale Identifier
Traditional Chinese with Hong Kong SCSzh_HK
Traditional Chinese for Taiwanzh_TW
Simplified Chinesezh_CN
Japaneseja_JP
Koreanko_KR
Argentina – Spanishes_ar
Beliz – Englishen_bz
Brazil - Portuguesept_br
Bolivia - Spanishes_bo
Chile - Spanishes_cl
Colombia - Spanishes_co
Costa Rica - Spanishes_cr
Dominican Republic - Spanishes_do
Ecuador - Spanishes_ec
Guatemala - Spanishes_gt
Guyana - Englishen_gy
Honduras - Spanishes_hn
Mexico - Spanishes_mx
Nicaragua - Spanishes_ni
Panama - Spanishes_pa
Peru - Spanishes_pe
Puerto Rico - Spanishes_pr
Paraguay - Spanishes_py
El Salvador - Spanishes_sv
Uruguay - Spanishes_uy
Venezuela - Spanishes_ve

During an installation in one of the listed locales, the Product Key window opens, prompting you to provide a valid product key. Enter a product key, and press Next to continue with the installation.

The Advanced Server Product Key

Fig. 1: The Advanced Server Product Key Window

performing_a_graphical_installation_on_windows invoking_the_graphical_installer_from_the_command_line using_stackbuilder_plus installation_troubleshooting