4 Installing Advanced Server with the Interactive Installer

Table of Contents Previous Next


4 Installing Advanced Server with the Interactive Installer

After navigating to the Software Downloads page, use the drop-down listboxes to select the Advanced Server version you wish to install and your platform, and then click the Download Now button. When the download completes, extract files using your system-specific file extractor.
During the installation process, the Advanced Server installer program copies a number of temporary files to the location specified by the TEMP or TMP environment variable (on Windows), or to the /tmp directory (on Linux). You can optionally specify an alternate location for the installer to place the temporary files by modifying or creating the TEMP environment variable.
Where temp_file_location specifies the alternate location for the temporary files.
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, on Linux use an export statement to set the value:
or on Windows, use a SET statement:
On Linux, enclose the options in double-quotes ("); on Windows, double-quotes are not required. 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:
Include the --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.
Include the --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.
Include the --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:

4 Installing Advanced Server with the Interactive Installer

Table of Contents Previous Next