Table of Contents Previous Next


3 Installing Advanced Server with the Interactive Installer

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 the TEMP environment variable.
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.
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 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:

3 Installing Advanced Server with the Interactive Installer

Table of Contents Previous Next