4.3.2 Using the Graphical Installer on a Linux System

Table of Contents Previous Next



To use the graphical installation wizard on a Linux system, you must have superuser privileges. To invoke the Setup wizard, open a Terminal window, navigate to the directory that contains the Advanced Server installer, and enter the command:
./edb-as10-server-10.x.x.x-linux-x64.run
The wizard opens a Language Selection popup; select an installation language from the drop-down listbox and click OK to continue to the Welcome window (shown in Figure 4.18).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\0693557c\one.png
Click Next to continue.
The License Agreement window (shown in Figure 4.19) opens.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\abfcba85\two.png
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.20.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\e68a2670\three.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 to the Installation Directory window (see Figure 4.21).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\b9fe8c4b\four.png
You can accept the default installation location, and click Next to continue, or click the File Browser icon to open a dialog and choose an alternate installation directory.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\a9f6bc3f\five.png
The Select Components window (shown in Figure 4.22) contains a list of the tools and utilities that you can install with the Advanced Server Setup wizard. To omit a component from your installation, deselect the check to the left of the component name.
The Setup wizard can install the following components while installing Advanced Server 10:
Select the EDB Postgres Advanced Server option to install Advanced Server.
Select the pgAdmin 4 option to install the pgAdmin 4 client. pgAdmin 4 provides a powerful graphical interface for database management and monitoring.
The Command Line Tools option installs command line tools and supporting client libraries including:
After selecting the components you wish to install, click Next to open the Additional Directories window (shown in Figure 4.23).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\77899dbb\six.png
Use the fields in the Additional Directories window to specify locations for the Advanced Server Data Directory and Write-Ahead Log (WAL) Directory.
The default Data Directory is /opt/edb/as10/data. You can use the file selector icon to specify an alternate location.
The default location of the Advanced Server Write-Ahead Log (WAL) Directory is opt/edb/as10/data/pg_wal. Accept the default location, or specify an alternate location with the file selector icon.
Click Next to continue to the Advanced Server Dialect window (shown in Figure 4.24).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\6503aa4d\seven.png
Use the drop-down listbox on the Advanced Server Dialect 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, 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.
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. 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 10.
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.25).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\f6831e27\eight.png
Advanced Server uses the password specified in the Password window for the database superuser. 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.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\f4081993\nine.png
Use the fields on the Additional Configuration window (shown in Figure 4.26) 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 (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 selections on the Additional Configuration window, click Next to open the Dynatune Dynamic Tuning: Server Utilization window (shown in Figure 4.27).
The 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.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\e6002fc2\ten.png
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 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 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.28).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\abf5b2b2\eleven.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 workloads.
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 the changes to take effect.
For more information about edb_dynatune and other performance-related topics, see the EDB Postgres Advanced Server 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.29) opens.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\bbf582d2\twelve.png
Check the box to the left of Install UPDATE Notification Service to install the service and enable notifications. When enabled, the Update Notification Service notifies you of any new updates and security patches available for your installation of Advanced Server.
The Pre Installation Summary window opens (shown in Figure 4.30).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\a975b59a\thirteen.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 to update any options.
The Ready to Install window (shown in Figure 4.31) confirms that the installer has the information it needs about your configuration preferences to install Advanced Server.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\f4011989\fourteen.png
Click Next to continue. The Setup wizard confirms the installation progress of Advanced Server via a progress bar (shown in Figure 4.32).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\e48a2878\fifteen.png
If you have elected to add StackBuilder Plus to your installation, the Setup wizard will offer to Launch Stack Builder Plus at exit? (see Figure 4.33).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\e4032962\sixteen.png
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