To specify that the installer should run in text mode, include the --mode text command line option when invoking the installer. Text-mode installations are useful if you need to install on a remote server using ssh tunneling (and have access to a minimal amount of bandwidth), or if you do not have access to a graphical interface.In text mode, the installer uses a series of command line questions to establish the configuration parameters. Text-mode installations are valid only on Linux systems.You must assume superuser privileges before performing a text-mode installation. To perform a text-mode installation on a Linux system, navigate to the directory that contains the installation binary file and enter:At any point during the installation process, you can press Ctrl-C to abort the installation.The text mode installer welcomes you to the Setup Wizard, and introduces the License Agreement. Use the Enter key to page through the license agreement:Welcome to the EDB Postgres Advanced Server Setup Wizard.
Please read the following License Agreement. You must accept the terms of this agreement before continuing with the installation.
Press [Enter] to continue:Press Enter to continue reviewing the license agreement. After displaying the license, the installer prompts you to accept the license:After reading the license agreement, enter y to accept the agreement and proceed with the installation. Enter n if you do not accept the license agreement; this will abort the installation.Next, the installer will prompt you for the User Authentication information associated with your EnterpriseDB user account. There is no charge to register for an EnterpriseDB user account; if you do not have a user account, visit to register.This installation requires a registration with EnterpriseDB.com. Please enter your credentials below. If you do not have an account, Please create one now on https://www.enterprisedb.com/user-login-registrationWhen prompted, enter the email address of a registered account, and then the corresponding password:By default, Advanced Server is installed in /opt/edb/as10:Enter an alternate location, or press Enter to accept the default and continue to the component selection portion of the installation process.Next, the installer prompts you individually for each component that is to be installed with Advanced Server:Enter Y or press Enter to accept the default value of yes after each component that you wish to include with the installation. Enter n to omit a component from the installation.EDB Postgres Advanced Server [Y/n] :
pgAdmin 4 [Y/n] :
StackBuilder Plus [Y/n] :
Command Line Tools [Y/n] :Press Y or enter after the EDB Postgres Advanced Server option to install Advanced Server 10.The StackBuilder Plus utility is a graphical tool that can update installed products, or download and add supporting modules (and the resulting dependencies) after your Advanced Server setup and installation completes. See Section 4.5 for more information about StackBuilder Plus.The Command Line Tools option installs command line tools and supporting client libraries including:
• After selecting components for installation, confirm that the list is correct by entering Y; enter n to iterate through the list of components a second time.Next, the installer prompts you to specify the location of the Additional Directories required by Advanced Server. The default data directory is /opt/edb/as10/data. You can specify an alternate location, or press Enter to accept the default and continue.The default location of the Advanced Server Write-Ahead Log (WAL) Directory is /opt/edb/as10/data/pg_wal. Press Enter to accept the default location and continue, or specify an alternate location.Please select a directory under which to store your Write-Ahead Logs.
Write-Ahead Log (WAL) Directory [/opt/edb/as10/data/pg_wal]:Advanced Server uses write-ahead logs to help ensure transaction safety and speed transaction processing; when you make a change to a table, the change is stored in shared memory and a record of the change is written to the write-ahead log. When you COMMIT a transaction, Advance Server writes contents of the write-ahead log to disk.Next, the installer prompts you to select an Advanced Server Dialect:EDB Postgres Advanced Server can be configured in one of two "Dialects" - 1) Compatible with Oracle or 2) Compatible with Postgres.If you select Compatible with Oracle, Advanced Server will be configured with appropriate data type conversions, time and date formats, Oracle-styled operators, dictionary views and more. This makes it easier to migrate or write new applications that are more compatible with the Oracle database.If you select Compatible with Postgres, Advanced Server will be configured with standard PostgeSQL data types, time/date formats and operators.The configuration mode specifies the server dialect with which Advanced Server will be compatible; you can choose between Compatible with Oracle and Compatible with PostgreSQL installation modes.Installing Advanced Server in Compatible with Oracle mode provides the following functionality:
• Oracle-styled concatenation rules (if you concatenate a string value with a NULL value, the returned value is the value of the string).
• Schemas (dbo and sys) compatible with Oracle databases added to the SEARCH_PATH.
Provides support for the DBMS_LOCK.SLEEP procedure. A partial implementation that provides support for DBMS_SESSION.SET_ROLE. This is not a comprehensive list of the compatibility features for Oracle included when Advanced Server is installed in Compatible with Oracle mode; more information about Advanced Server is available in the Database Compatibility for Oracle Developer’s Guide available at:If you choose to install in Compatible with Oracle mode, the Advanced Server superuser name is enterprisedb.When installed in Compatible with PostgreSQL mode, Advanced Server exhibits complete compatibility with Postgres version 10. For more information about PostgreSQL functionality, visit the official PostgreSQL website at:If you choose to install in Compatible with PostgreSQL mode, the Advanced Server superuser name is postgres.Press Enter to accept the default configuration mode (Compatible with Oracle) and continue; enter 2 and press Enter to install in Compatible with PostgreSQL mode.Please provide a password for the database superuser (enterprisedb). A locked Unix user account (enterprisedb) will be created if not present.Advanced Server uses the password specified for the database superuser. The password must conform to any security policies existing on the Advanced Server host.After entering a password in the Password field, confirm the password and press Enter to continue.The installer prompts you for Additional Configuration information:When prompted, enter the Port that the Advanced Server service will monitor for connections. By default, Advanced Server chooses the first available port after port number 5444:Specify a Locale by entering a locale number from the list shown. Accept the Default locale value to instruct the installer to use the system locale as the server locale.When prompted, enter Y (or press Enter to accept the default value) to install the sample tables and procedures for the database dialect specified by the compatibility mode (Oracle or PostgreSQL):Dynatune functionality allows Advanced Server to make optimal usage of the system resources available on the host machine. To facilitate performance tuning through Dynatune, the installer prompts you first for Server Utilization information:The edb_dynatune configuration parameter determines how Advanced Server allocates system resources. Your selection will establish the initial value of edb_dynatune.
• Specify Development to set the value of edb_dynatune to 33. A low value dedicates the least amount of the host machine’s resources to the database server. This is a good choice for a development machine.
• Specify General Purpose to set the value of edb_dynatune to 66. A mid-range value dedicates a moderate amount of system resources to the database server. This would be a good setting for an application server with a fixed number of applications running on the same host as Advanced Server.
• Specify Dedicated to set the value of edb_dynatune to 100. A high value dedicates most of the system resources to the database server. This is a good choice for a dedicated server host.Enter a value of 1, 2, or 3, or accept the default value of 2 (to indicate that the server will be used for General Purpose processing) and press Enter to continue.Next, the Advanced Server installer prompts for information about the type of workload the system will be processing:The installer uses the Workload Profile to establish the initial value of the edb_dynatune_profile configuration parameter. The edb_dynatune_profile parameter controls performance-tuning aspects based on the type of work that the server performs.
• Enter 1 to indicate Transaction Processing (OLTP systems) and set the value of edb_dynatune_profile to oltp. Recommended when Advanced Server is supporting heavy online transaction processing workloads.
• Enter 2 to indicate General Purpose (OLTP and reporting workloads) and set the value of edb_dynatune_profile to mixed. Recommended for servers that provide a mix of transaction processing and data reporting.
• Enter 3 to indicate Reporting (Complex queries or OLAP workloads) and set the value of edb_dynatune_profile to reporting. Recommended for database servers used for heavy data reporting.After choosing a Workload Profile, press Enter to continue.After the installation is complete, you can adjust the values of edb_dynatune and edb_dynatune_profile by editing the postgresql.conf file, located in the data directory of your Advanced Server installation, and restarting the server.For more information about edb_dynatune and other performance-related topics, see the EDB Postgres Advanced Server Guide available at:If enabled, the Update Notification Service notifies you of any available updates and security patches for your installation of Advanced Server.By default, the installer specifies that Advanced Server should enable the notification service when the system boots; specify n to disable the notification service, or accept the default, and press Enter to continue to the Pre Installation Summary:The Pre Installation Summary lists the options specified during the installation setup process; review the listing and press Enter to continue; press Enter again to start the installation process.