4.3.1 Using the Graphical Installer with Windows

Table of Contents Previous Next



To perform an installation using the graphical wizard on a Windows system, you must have administrator privileges. To start the Setup wizard, assume administrator privileges, and double-click the edb-as96-meta-9.6.x.x-windows-x64 executable file.
To install Advanced Server on some versions of Windows you may be required to right click on the file and select Run as Administrator from the context menu to invoke the installer with Administrator privileges.
The 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.3):
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\9e14f8f2\Screen Shot 2016-09-23 at 1.04.22 PM.png
Click Next to continue.
The EnterpriseDB License Agreement (see Figure 4.4) opens.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\8e9dc988\Screen Shot 2016-09-23 at 1.05.03 PM.png
The User Authentication window opens, as shown in Figure 4.5.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\8e94c9b3\Screen Shot 2016-09-23 at 1.05.32 PM.png
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.
The Installation Directory window opens, as shown in Figure 4.6.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\8e1fc80e\Screen Shot 2016-09-23 at 1.06.48 PM.png
You can accept the default installation location, and click Next to continue, or optionally click the File Browser icon to open the Browse For Folder dialog (shown in Figure 4.7) to choose an alternate installation directory.
Use the tree control displayed on the Browse For Folder dialog to navigate to an alternate installation directory, or create a new installation directory by selecting the Make New Folder button, 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.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\d163620d\Screen Shot 2016-09-23 at 1.07.16 PM.png
The Select Components window (shown in Figure 4.8) contains a list of optional components that you can install with the Advanced Server Setup wizard. Note that if you do not have Java installed on your system, those components that require Java are disabled and will not be installed. You can omit a module from the Advanced Server installation by deselecting the box next to the components name.
The Setup wizard can install the following components while installing Advanced Server 9.6:
Select the EDB Postgres Advanced Server option to install Advanced Server 9.6.
Select the EDB Postgres Connectors option to install the client connector API’s for JDBC, .NET, OCI and ODBC. The client connectors facilitate application connectivity for Advanced Server.
If you have Java (version 7 or 8) or OpenJDK (version 1.7 or 1.8) installed on your system, you can use the EDB Postgres Migration Toolkit option to install Migration Toolkit. Migration Toolkit is a command line migration utility that facilitates migration from MySQL, Oracle, Microsoft SQL Server and Sybase databases.
See the EDB Postgres Migration Guide for more information about Migration Toolkit available from the EnterpriseDB website at:
Select the EDB Postgres pgAdmin 4 option to install the pgAdmin 4 client. pgAdmin 4 provides a powerful graphical interface for database management and monitoring.
If you have Java installed on your system, you can select the EDB Postgres Advanced Server EDB*Plus option to install EDB*Plus. EDB*Plus is the Advanced Server SQL command line interface that offers compatibility with Oracle’s SQL Plus commands.
Check the box next to EDB Postgres Advanced Server Slony Replication to specify that Slony should be included in the installation process. Slony facilitates master-standby replication suited for large databases with a limited number of standby systems.
Select the EDB Postgres pgBouncer option to install PgBouncer. 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.
StackBuilder Plus is included with the installation of Advanced Server and its core supporting components. The StackBuilder Plus utility is a graphical tool that can update installed products, or download and add any omitted modules (and the resulting dependencies) after your Advanced Server setup and installation completes. See Section 4.5 for more information about StackBuilder Plus.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\9e15f8d0\Screen Shot 2016-09-23 at 1.08.45 PM.png
By default, the Advanced Server data files are saved to:
You can accept the default location for the data files, or use the File Browser icon to open the Browse For Folder dialog.
The default location of the Advanced Server Write-Ahead Log (WAL) Directory is:
Accept the default file locations, or specify alternate locations with the File Browser icon; click Next to continue to the Configuration Mode window (shown in Figure 4.10).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\8e1dc888\Screen Shot 2016-09-23 at 1.09.14 PM.png
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 in Compatible with Oracle mode; 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:
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.
Provides support for the DBMS_LOCK.SLEEP procedure.
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 found in the Database Compatibility for Oracle Developer’s Guide available from the EnterpriseDB website 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 PostgreSQL version 9.6. 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.11).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\4263d7c7\Screen Shot 2016-09-23 at 1.18.01 PM.png
Advanced Server uses the password specified on the Password window for the database superuser and the pgAgent service. The specified password must conform to any security policies existing on the Advanced Server host.
After you enter a password in the Password field, confirm the password in the Retype Password field, and click Next to continue.
The Additional Configuration window opens (shown in Figure 4.12).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\0d9c4c0d\Screen Shot 2016-09-23 at 1.19.22 PM.png
Use the fields on the Additional Configuration window to specify installation details:
Use the Port field to specify the port number that Advanced Server should listen to for connection requests from client applications. The default is 5444.
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.
By default, the Setup wizard installs corresponding sample data for the server dialect specified by the compatibility mode (Oracle or PostgreSQL). Clear the checkbox next to Install sample tables and procedures if you do not wish to have sample data installed.
After verifying the information on the Additional Configuration window, click Next to open the Dynatune Dynamic Tuning: Server Utilization window (shown in Figure 4.13).
The graphical Setup 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 on which it is installed.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\1f177bd9\Screen Shot 2016-09-23 at 1.20.07 PM.png
The edb_dynatune configuration parameter determines how Advanced Server allocates system resources. Use the radio buttons on the Server Utilization window to 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 dedicated server host.
After the installation is complete, you can adjust the value of edb_dynatune by editing the postgresql.conf file, located in the data directory of your Advanced Server installation. After editing the postgresql.conf file, you must restart the server for your 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.14).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\0d1d4d0e\Screen Shot 2016-09-23 at 1.20.36 PM.png
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. Recommended when Advanced Server is supporting heavy online transaction processing.
Select General Purpose (OLTP and reporting workloads) to specify an edb_dynatune_profile value of mixed. Recommended for servers that provide a mix of transaction processing and data reporting.
Select Reporting (Complex queries or OLAP workloads) to specify an edb_dynatune_profile value of reporting. Recommended for database servers used for heavy data reporting.
After the installation is complete, you can adjust the value of edb_dynatune_profile by editing the postgresql.conf file, located in the data directory of your Advanced Server installation. After editing the postgresql.conf file, you must restart the server for your changes to take effect.
For more information about edb_dynatune and other performance-related topics, see the EDB Postgres Advanced Server Guide available from the EnterpriseDB website at:
Click Next to continue. The Advanced Configuration window (shown in Figure 4.15) opens.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\42e0d6ef\Screen Shot 2016-09-23 at 1.22.33 PM.png
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
The Pre Installation Summary opens as shown in Figure 4.16.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\0d144d14\Screen Shot 2016-09-23 at 1.23.39 PM.png
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 and update any options.
The Ready to Install window (see Figure 4.17) confirms that the installer has the information it needs about your configuration preferences to install Advanced Server. Click Next to continue.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\d36964b7\Screen Shot 2016-09-23 at 1.29.00 PM.png
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\9e9df9c4\Screen Shot 2016-09-23 at 1.32.14 PM.png
Before the Setup wizard completes the Advanced Server installation, it offers to Launch StackBuilder Plus at exit? (see Figure 4.19).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\9e1cf8c7\Screen Shot 2016-09-23 at 1.34.30 PM.png
You can clear the StackBuilder Plus checkbox and click Finish to complete the Advanced Server installation, or accept the default and proceed to StackBuilder Plus.


Table of Contents Previous Next