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:
You can invoke the graphical installer in different installation modes to perform an Advanced Server installation:
- For information about using the graphical installer, see Performing a Graphical Installation on Windows.
- For information about performing an unattended installation, see Performing an Unattended Installation.
- For information about performing an installation with limited privileges, see Performing an Installation with Limited Privileges.
- For information about the command line options you can include when invoking the installer, see Reference - Command Line Options.
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:
temp_file_location specifies the alternate location for the temporary files and must match the permissions with the
TEMP environment variable.
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:
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
For more information about using
initdb cluster configuration options, see the PostgreSQL Core Documentation available at:
In addition to the cluster configuration options documented in the PostgreSQL core documentation, Advanced Server supports the following
--no-redwood-compat keywords to instruct the server to create the cluster in PostgreSQL mode. When the cluster is created in PostgreSQL mode, the name of the database superuser will be
postgres, the name of the default database will be
postgres, and Advanced Server’s features compatible with Oracle databases will not be available to the cluster.
--redwood-like keywords to instruct 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 keywords to create a cluster that uses a default ICU (International Components for Unicode) collation for all databases in the cluster. For more information about Unicode collations, please refer to the EDB Postgres Advanced Server Guide available at:
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.
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.
|Traditional Chinese with Hong Kong SCS|
|Traditional Chinese for Taiwan|
|Argentina – Spanish|
|Beliz – English|
|Brazil - Portuguese|
|Bolivia - Spanish|
|Chile - Spanish|
|Colombia - Spanish|
|Costa Rica - Spanish|
|Dominican Republic - Spanish|
|Ecuador - Spanish|
|Guatemala - Spanish|
|Guyana - English|
|Honduras - Spanish|
|Mexico - Spanish|
|Nicaragua - Spanish|
|Panama - Spanish|
|Peru - Spanish|
|Puerto Rico - Spanish|
|Paraguay - Spanish|
|El Salvador - Spanish|
|Uruguay - Spanish|
|Venezuela - Spanish|
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.
performing_a_graphical_installation_on_windows invoking_the_graphical_installer_from_the_command_line using_stackbuilder_plus installation_troubleshooting
- On this page
- Locales Requiring Product Keys