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:# ./ppasmeta-9.4.x.x-linux.run --mode textAt any point during the installation process, you can press Ctrl-C to abort the installation.The installation language is the language used by the installer during the installation process. The default value (English) is displayed in square braces to the right left of the prompt (); press Enter to accept the default value and continue, or change the value to specify an alternate installation language.If the installer detects that you do not have Java installed on your system, it will alert you that it will not install Java-based components. Select Y or Enter to continue, or exit the installation and install Java before re-opening the installer.The text mode installer welcomes you to the Setup Wizard (shown in Figure 4.38), and introduces the License agreement. Use the Enter key to page through the License agreement.After reading the license agreement, enter y to accept the agreement and proceed with the installation (see Figure 4.39). Enter n if you do not accept the license agreement; this will abort the installation. Press Enter to proceed.Next, Advanced Server will prompt you for the User Authentication information associated with your EnterpriseDB user account (see Figure 4.40). There is no charge to register for an EnterpriseDB user account; if you do not have a user account, visit to register.When prompted, enter the email address of a registered account, and then the corresponding password. Press Enter to continue to the next prompt (shown in Figure 4.41).By default, Advanced Server is installed in /opt/PostgresPlus/9.4AS. Enter an alternate location, or press Enter to accept the default and continue to the component selection portion of the installation process (see Figure 4.42).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.Select the Database Server option to install Postgres Plus Advanced Server 9.4.Select the Connectors option to install the client connector API’s for JDBC, .NET, OCI and ODBC. The client connectors facilitate application connectivity for Advanced Server.Select the Infinite Cache option to install the icache daemon.The installation wizard can optionally install the icache daemon on a remote icache server without including a complete installation of Advanced Server. To install only the icache daemon, deselect the other components shown on the Select Components window before clicking Next.For more information about using Infinite Cache and the icache daemon, see the Postgres Plus Enterprise Edition Guide, available at:Select the Migration Toolkit option to install Migration Toolkit. Migration Toolkit is a command line migration utility that facilitates migration from MySQL, Oracle, SQL Server and Sybase databases. See the Postgres Plus Advanced Server Migration Guide for more information about Migration Toolkit.Select the Postgres Enterprise Manager Client option to install the PEM Client application. The PEM Client provides a powerful graphical interface for database management and monitoring.pgpool-II provides load balancing, connection pooling, high availability, and connection limits for Advanced Server databases.If you are installing pgpool-II, include the pgpool-II Extensions to provide the extensions required by the server to implement pgpool-II functionality.Select the EDB*Plus option to install EDB*Plus. EDB*Plus is the Advanced Server command line interface that offers compatibility with Oracle’s SQL Plus commands.Check the box next to Slony Replication to specify that Slony-I should be included in the Advanced Server installation. Slony-I facilitates master-standby replication suited for large databases with a limited number of standby systems.PgBouncer is a lightweight connection pooling utility for Advanced Server. Connection pooling can dramatically reduce processing time and resources for systems maintaining client connections to one or more databases.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. Press Enter to continue.Next, the installer prompts you to specify the location of the additional directories required by Advanced Server (see Figure 4.43).The default data directory is /opt/PostgresPlus/9.4AS/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 Directory is /opt/PostgresPlus/9.4AS/data/pg_xlog. Press Enter to accept the default location and continue, or specify an alternate location.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.The installer prompts you to select a Configuration Mode (see figure 4.44). The configuration mode specifies the server dialect that Advanced Server will be compatible with; you can choose between Oracle Compatible and PostgreSQL Compatible installation modes.Installing Advanced Server in Oracle Compatible mode provides the following functionality:
• Support for 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.
This is not a comprehensive list of the compatibility features included when Advanced Server is installed in Oracle Compatible mode. You can find more information about the compatible functionality of Advanced Server in the Database Compatibility for Oracle Developer’s Guide, available at:If you choose to install in Oracle Compatible mode, the Advanced Server superuser name is enterprisedb.When installed in PostgreSQL Compatible mode, Advanced Server exhibits complete compatibility with Postgres version 9.4. For more information about Postgres functionality, see the PostgreSQL core documentation available at:If you choose to install in PostgreSQL Compatible mode, the Advanced Server superuser name is postgres.Press Enter to accept the default configuration mode (Oracle Compatible) and continue; enter 2 and press Enter to install in PostgreSQL Compatible mode. The installer prompts you for a database superuser password (see Figure 4.45).Advanced Server uses the password specified on the Password window for the database superuser and pgAgent service. The specified 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 asks for Additional Configuration information (see Figure 4.46).
• 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).
• When the Update Notification Service prompt appears, enter Y to indicate that Advanced Server should notify you of any available updates and security patches for your installation of Postgres Plus Advanced Server.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 for Server Utilization and Workload Profile information (see Figure 4.47).The edb_dynatune configuration parameter determines how Advanced Server allocates system resources. Specify a usage type for the Advanced Server installation to 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 host machine that is dedicated to running Advanced Server.Enter a value of 1, 2 or 3, or simply accept the default value of 2 (to indicate that the server will be used for General Purpose processing) and press Enter to continue.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.
• Enter 2 to indicate General Purpose (OLTP and reporting workloads) and set the value of edb_dynatune_profile to mixed.
• Enter 3 to indicate Reporting (Complex queries or OLAP workloads) and set the value of edb_dynatune_profile to 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 and restarting the server.For more information about edb_dynatune and other performance-related topics, see the Postgres Plus Enterprise Edition Guide.The installer continues, requesting configuration information for the PgBouncer and pgAgent services (see Figure 4.48).PgBouncer is a lightweight connection pooling utility for Advanced Server. Connection pooling can dramatically reduce processing time and resources for systems maintaining client connections to one or more databases.Please Note: The pgbouncer program stores a list of users and passwords in clear-text form in the following file:By default, the file is located in a directory that is accessible only to the cluster owner (by default, enterprisedb), but administrators should take note of the file and maintain permissions in a manner that secures the file from un-trusted users.By default, Advanced Server expects PgBouncer to listen on port 6432; update the Listening Port field, or accept the default, and press Enter to continue.pgAgent is a job scheduling agent for Postgres, capable of running multi-step batch/shell and SQL tasks on complex schedules. pgAgent also provides background support for the DBMS_JOB built-in package compatible with Oracle.If enabled, the Update Notification Service notifies you of any available updates and security patches for your installation of Postgres Plus Advanced Server.By default, the installer specifies that Advanced Server should start the services when the system boots; specify n to disable PgBouncer, pgAgent and the Update Notification Service, or accept the defaults, and press Enter to continue to the Pre Installation Summary (shown in Figure 4.49).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. The installer extracts the Advanced Server files and proceeds with the installation (shown in Figure 4.50).The dialog lists each module as it is being installed, and informs you when the installation is complete (see Figure 4.51).