Performing a Graphical Installation on Windows v11
A graphical installation is a quick and easy way to install Advanced Server 11 on a Windows system. Use the wizard's dialogs to specify information about your system and system usage; when you have completed the dialogs, the installer performs an installation based on the selections made during the setup process.
To invoke the wizard, you must have administrator privileges. Assume administrator privileges, and double-click the edb-as11-server-11.x.x-x-windows-x64
executable file.
Note
To install Advanced Server on some versions of Windows, you may be required to right click on the file icon and select Run as Administrator
from the context menu to invoke the installer with Administrator
privileges.
When the Language Selection
popup opens, select an installation language and click OK
to continue to the Setup
window.
Click Next
to continue.
The EnterpriseDB License Agreement
window opens.
Carefully review the license agreement before highlighting the appropriate radio button; click Next
to continue.
The Installation Directory
window opens.
By default, the Advanced Server installation directory is:
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 to choose an alternate installation directory.
Note
The data
directory of a production database should not be stored on an NFS file system.
The Select Components
window contains a list of optional components that you can install with the Advanced Server Setup
wizard. 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 11:
EDB Postgres Advanced Server
Select the EDB Postgres Advanced Server
option to install Advanced Server 11.
pgAdmin 4
Select the pgAdmin 4
option to install the pgAdmin 4 client. pgAdmin 4 provides a powerful graphical interface for database management and monitoring.
StackBuilder Plus
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 Using StackBuilder Plus for more information about StackBuilder Plus.
Command Line Tools
The Command Line Tools
option installs command line tools and supporting client libraries including:
- libpq
- psql
- EDB*Loader
- ecpgPlus
- pg_basebackup, pg_dump, and pg_restore
- pg_bench and more.
Note
The Command Line Tools
are required if you are installing Advanced Server or pgAdmin 4.
After selecting the components you wish to install, click Next
to open the Additional Directories
window.
By default, the Advanced Server data
files are saved to:
The default location of the Advanced Server Write-Ahead Log (WAL) Directory
is:
Advanced Server uses write-ahead logs to promote 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 perform a COMMIT
, Advanced Server writes contents of the write-ahead log to disk.
Accept the default file locations, or use the File Browser
icon to select an alternate location; click Next
to continue to the Advanced Server Dialect
window.
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, Advanced Server installs in Compatible with Oracle
mode; you can choose between Compatible with Oracle
and Compatible with PostgreSQL
installation modes.
Compatible with Oracle
If you select Compatible with Oracle
, the installation will include the following features:
- Data dictionary views that is compatible with Oracle databases.
- Oracle data type conversions.
- Date values displayed in a format compatible with Oracle syntax.
- 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
andsys
) compatible with Oracle databases added to theSEARCH_PATH
. - Support for the following Oracle built-in packages:
Package | Functionality compatible with Oracle Databases |
---|---|
dbms_alert | Provides the capability to register for, send, and receive alerts. |
dbms_aq | Provides queueing functionality for Advanced Server. |
dbms_aqadm | Provides supporting functionality for dbms_aq. |
dbms_crypto | Provides a way to encrypt or decrypt RAW, BLOB or CLOB data. |
dbms_job | Implements job-scheduling functionality. |
dbms_lob | Provides the ability to manage large objects. |
dbms_lock | Provides support for the DBMS_LOCK.SLEEP procedure. |
dbms_mview | Provides a way to manage and refresh materialized views. |
dbms_output | Provides the ability to display a message on the client. |
dbms_pipe | Provides the ability to send a message from one session and read it in another session. |
dbms_profiler | Collects and stores performance data about PL/pgSQL and SPL statements. |
dbms_random | Provides a way to generate random numbers. |
dbms_rls | Implements row level security. |
dbms_scheduler | Provides a way to create and manage Oracle-style jobs. |
dbms_session | A partial implementation that provides support for DBMS_SESSION.SET_ROLE . |
dbms_sql | Implements use of Dynamic SQL |
dbms_utility | Provides a collection of misc functions and procedures. |
utl_encode | Provides a way to encode or decode data. |
utl_file | Provides a way for a function, procedure or anonymous block to interact with files stored in the server’s file system. |
utl_http | Provides a way to use HTTP or HTTPS to retrieve information found at a URL. |
utl_mail | Provides a simplified interface for sending email and attachments. |
utl_raw | Provides a way to manipulate or retrieve the length of raw data types. |
utl_smtp | Implements smtp email functions. |
utl_url | Provides a way to escape illegal and reserved characters in a URL. |
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, see the Database Compatibility for Oracle Developers Built-in Package Guide available from the EnterpriseDB website at:
https://www.enterprisedb.com/docs
If you choose to install in Compatible with Oracle
mode, the Advanced Server superuser name is enterprisedb
.
Compatible with PostgreSQL
If you select Compatible with PostgreSQL
, Advanced Server will exhibit compatibility with PostgreSQL version 11. If you choose to install in Compatible with PostgreSQL
mode, the default Advanced Server superuser name is postgres
.
For detailed information about PostgreSQL functionality, visit the official PostgreSQL website at:
After specifying a configuration mode, click Next
to continue to the Password
window.
Advanced Server uses the password specified on 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.
The Additional Configuration
window opens.
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 is5444
. - 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 toLocale
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
orPostgreSQL)
. Clear the check box next toInstall 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.
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.
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 ofedb_dynatune
to33
. 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 ofedb_dynatune
to66
. 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 ofedb_dynatune
to100
. 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.
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 anedb_dynatune_profile
value ofoltp
. Recommended when Advanced Server is supporting heavy online transaction processing. - Select
General Purpose (OLTP and reporting workloads)
to specify anedb_dynatune_profile
value ofmixed
. Recommended for servers that provide a mix of transaction processing and data reporting. - Select
Reporting (Complex queries or OLAP workloads)
to specify anedb_dynatune_profile
value ofreporting
. 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:
https://www.enterprisedb.com/docs
Click Next
to continue. The Update Notification Service
window opens.
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 service when the system boots; clear the Install Update Notification Service
check box, or accept the default, and click Next
to continue.
The Pre Installation Summary
opens.
The Pre Installation Summary
provides an overview of the options specified during the Setup
process. Review the options before clicking Next
; click Back
to navigate back through the dialogs and update any options.
The Ready to Install
window confirms that the installer has the information it needs about your configuration preferences to install Advanced Server. Click Next
to continue.
As each supporting module is unpacked and installed, the module’s installation is confirmed with a progress bar.
Before the Setup
wizard completes the Advanced Server installation, it offers to Launch StackBuilder Plus at exit?
You can clear the StackBuilder Plus
check box and click Finish
to complete the Advanced Server installation, or accept the default and proceed to StackBuilder Plus.
EDB Postgres StackBuilder Plus is included with the installation of Advanced Server and its core supporting components. StackBuilder Plus 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 Using StackBuilder Plus for more information about StackBuilder Plus.