To use the graphical installation wizard on a Linux system, you must have superuser privileges. To invoke the installation wizard, open a Terminal window, navigate to the directory that contains the unpacked Advanced Server binary file, and enter the command:./ppasmeta-9.5.x.x-linux.runThe wizard opens a Language Selection popup; select an installation language from the drop-down listbox and click OK to continue. If you do not have Java installed on your system, the installer will ask you to confirm that you wish to continue the installation without installing Java based components; click Yes to continue to the Setup window (shown in Figure 4.19).Click Next to continue. The License Agreement window (shown in Figure 4.20) opens.Review the EnterpriseDB license agreement carefully before selecting the radio button next to I accept the agreement. Click Next to continue to the User Authentication window.The User Authentication window opens, as shown in Figure 4.21:Before continuing, you must provide the email address and password associated with your EnterpriseDB user account. Registration is free; if you do not have an EnterpriseDB user account, click the link provided to open a web browser, and enter your user information.Enter the email address of a registered account in the Email field, and the corresponding password in the Password field, and click Next to continue to the Installation Directory window (see Figure 4.22).You can accept the default installation location, and click Next to continue, or optionally click the File Browser button to open the Browse For Folder dialog (shown in Figure 4.23) to choose an alternate installation directory.Use the file browser dialog to navigate to an alternate installation directory, or create a new installation directory by selecting the Add Folder icon, and entering a name for the new folder.After selecting an alternate installation directory, click OK to continue. When you return to the Installation Directory window, click Next to open the Select Components window.The Select Components window (shown in Figure 4.24) contains a list of the utilities that you can install with the Advanced Server installation wizard. If your system does not include a Java installation, those components that are dependent on Java will be disabled. You can skip the installation of a module by clearing the checkmark next to the component name.Select the Database Server option to install Advanced Server 9.5.Select the Connectors option to install the client connector API’s for JDBC, 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 EDB Postgres (Postgres Plus) Enterprise Edition Guide, available at:If you have Java installed on your system, you can use 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 EDB Postgres Migration Toolkit Guide for more information about Migration Toolkit, available at: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.Use the pgpool-II option to include pgpool-II in the Advanced Server installation. pgpool-II provides load balancing, connection pooling, high availability, and connection limits for Advanced Server databases.If you are installing pgpool-II, check the box next to pgpool-II Extensions to include the server 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.Please Note that the EDB*Plus installation option will only be enabled if your system contains Java.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.The StackBuilder Plus package manager is a graphical tool that can easily download and add any omitted modules (and the resulting dependencies) after the installation is complete. StackBuilder Plus is included in the Advanced Server installation. See , Using StackBuilder Plus for more information about StackBuilder Plus.After editing the list of supporting components, click Next to open the Additional Directories window (shown in Figure 4.25).Use the fields on the Additional Directories window to specify locations for the Advanced Server data directory and write-ahead log directory.The default Data Directory is /opt/PostgresPlus/9.5AS/data. You can optionally use the file selector button to specify an alternate location.The default location of the Advanced Server Write-Ahead Log Directory is /PostgresPlus/9.5AS/data/pg_xlog. Accept the default location, or specify an alternate location with the file selector button.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 do a COMMIT, Advance Server writes contents of the write-ahead log to disk.Click Next to continue to the Configuration Mode window (shown in Figure 4.26).Use the drop-down listbox on the Configuration Mode window to choose a server dialect. The server dialect specifies the compatibility features supported by Advanced Server.By default, Advance Server installs with database compatibility with Oracle; you can choose between Compatible with Oracle and Compatible with PostgreSQL installation modes.If you select Compatible with Oracle on the Configuration Mode dialog, the installation will include the following features:
• 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.
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. For more information, refer to 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 9.5. For more information about PostgreSQL functionality, review the PostgreSQL core documentation at:If you choose to install in Compatible with PostgreSQL mode, the Advanced Server superuser name is postgres.After specifying a configuration mode, click Next to continue to the Password window (shown in Figure 4.27).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, and confirming the password in the Retype Password field, click Next to continue.Use the fields on the Additional Configuration window (shown in Figure 4.28) to specify installation details:
• The Port field specifies the port number that Advanced Server should listen to for connection requests from client applications.
• If the Locale field is set to [Default Locale], Advanced Server uses the system locale as the working locale. Use the drop-down listbox next to Locale to specify an alternate locale for Advanced Server.
• Check the box next to Install sample tables and procedures to instruct the installation wizard to install the corresponding sample data for the server dialect specified on the Compatibility Mode window.After verifying the information on the Additional Configuration window, click Next to open the Dynatune Dynamic Tuning: Server Utilization window (shown in Figure 4.29).The installation wizard facilitates performance tuning via the Dynatune Dynamic Tuning feature. Dynatune functionality allows Advanced Server to make optimal usage of the system resources available on the host machine.The edb_dynatune configuration parameter determines how Advanced Server allocates system resources. The radio buttons on the Server Utilization window set the initial value of the edb_dynatune configuration parameter.
• Select 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.
• Select 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.
• Select 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.After the installation is complete, you can adjust the value of edb_dynatune by editing the postgresql.conf file. After editing the postgresql.conf file, you must restart the server for the changes to take effect.Select the appropriate setting for your system, and click Next to continue to the Dynatune Dynamic Tuning: Workload Profile window (shown in Figure 4.30).Use the radio buttons on the Workload Profile window to specify 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.
• Select Transaction Processing (OLTP systems) to specify an edb_dynatune_profile value of oltp.
• Select General Purpose (OLTP and reporting workloads) to specify an edb_dynatune_profile value of mixed.
• Select Reporting (Complex queries or OLAP workloads) to specify an edb_dynatune_profile value of reporting.After the installation is complete, you can adjust the value of edb_dynatune_profile by editing the postgresql.conf file. After editing the postgresql.conf file, you must restart the server for the changes to take effect.For more information about edb_dynatune and other performance-related topics, see the EDB Postgres (Postgres Plus) Enterprise Edition Guide, available at:After selecting the radio button that best describes the use of the system, click Next to continue. The Advanced Configuration window (shown in Figure 4.31) opens.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. By default, Advanced Server expects PgBouncer to listen on port 6432.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 untrusted users.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 databases.When enabled, the Update Notification Service notifies you of any new updates and security patches available for your installation of Advanced Server.By default, Advanced Server is configured to start the pgBouncer, pgAgent and Update Notification services when the system boots; clear applicable Service Configuration checkboxes, or accept the defaults, and click Next to continue.The Pre Installation Summary opens (shown in Figure 4.32).The Pre Installation Summary provides an overview of the options specified during the Setup process. Review the options before clicking Next; use the Back button to navigate back through the dialogs to modify installation options.The Ready to Install window (shown in Figure 4.33) confirms that the installer has the information it needs about your configuration preferences to install Advanced Server.Click Next to continue. The installation wizard confirms the installation progress of Advanced Server via a series of progress bars (shown in Figure 4.34).Pop-up dialogs confirm the installation of the server and individual components (shown in Figure 4.35).Before the installation wizard completes the Advanced Server installation, it offers to Launch Stack Builder Plus at exit (see Figure 4.36).You can optionally clear the StackBuilder Plus box and click Finish to complete the Advanced Server installation or accept the default and proceed to StackBuilder Plus.