You can use the Advanced Server graphical installer or an RPM package to add the JDBC Connector to your installation.Before using an RPM installer to install the JDBC connector, you must first create and configure the EnterpriseDB repository file, providing a user name and password that allows access to the files in the repository. To request credentials to access the repository, visit the following website:The name of the package that creates the repository file for Advanced Server is edb-repo. You can download the package at:After downloading the repository configuration file, assume superuser privileges, and use the following command to create the repository configuration file:rpm -Uvh edb-repo-x.x-x.noarch.rpmThe installer creates a repository configuration file named edb.repo; the file resides in /etc/yum.repos.d. The file contains entries for each of the EnterpriseDB repositories; to install the connector, you must enable the entry for the enterprisedb-tools repository:[enterprisedb-tools]
name=EnterpriseDB Tools $releasever - $basearch
1. Replace the user_name and password placeholders in the baseurl specification with your user name and the repository password.
2. Replace the 0 next to enabled with a 1.After modifying the content of the repository configuration file, you can use the yum install command to install the connector; use the command:During the installation, yum may encounter a dependency that it cannot resolve. If it does, it will provide a list of the required dependencies that you must manually resolve.You can use the zypper package manager to install the connector on an SLES 12 host. zypper will attempt to satisfy package dependencies as it installs a package, but requires access to specific repositories that are not hosted at EnterpriseDB.Before installing the connector, use the following commands to add EnterpriseDB repository configuration files to your SLES host:zypper addrepo https://zypp.enterprisedb.com/suse/epas96-sles.repo
zypper addrepo https://zypp.enterprisedb.com/suse/epas-sles-tools.repo
zypper addrepo https://zypp.enterprisedb.com/suse/epas-sles-dependencies.repoEach command creates a repository configuration file in the /etc/zypp/repos.d directory. The files are named:After creating the repository configuration files, use the zypper refresh command to refresh the metadata on your SLES host to include the EnterpriseDB repositories:/etc/zypp/repos.d # zypper refresh
Repository 'SLES12-12-0' is up to date.
Repository 'SLES12-Pool' is up to date.
Repository 'SLES12-Updates' is up to date.
Retrieving repository 'EDB Postgres Advanced Server 9.6 12 - x86_64' metadata -----------------------[\]Authentication required for 'https://zypp.enterprisedb.com/9.6/suse/suse-12-x86_64'
Password:Retrieving repository 'EDB Postgres Advanced Server 9.6 12 - x86_64' metadata...................................[done]
Building repository 'EDB Postgres Advanced Server 9.6 12 - x86_64' cache..........................[done]
All repositories have been refreshed.
...When prompted for a User Name and Password, provide your connection credentials for the EnterpriseDB repository. If you need credentials, contact EnterpriseDB at:Before installing EDB Postgres Advanced Server or supporting components, you must also add SUSEConnect and the SUSE Package Hub extension to the SLES host, and register the host with SUSE, allowing access to SUSE repositories. Use the commands:You can use the EnterpriseDB Connectors Installation wizard to add the JDBC connector to your system; the wizard is available at:This section demonstrates using the Installation Wizard to install the Connectors on a Linux system. (You can follow the same procedure to install the Connectors on a Windows system. Download the installer, and then, right-click on the installer icon, and select Run As Administrator from the context menu.) The installation wizard opens as shown in Figure 3.1.Click Next to continue.Use the Installation Directory dialog (see Figure 3.2) to specify the directory in which the connector will be installed, and click Next to continue.Click Next on the Ready to Install dialog (see Figure 3.3) to start the installation; popup dialogs confirm the progress of the installation wizard.When the wizard informs you that it has completed the setup, click the Finish button to exit the dialog (see Figure 3.4).You can also use StackBuilder Plus to add or update the connector on an existing Advanced Server installation; to open StackBuilder Plus, select StackBuilder Plus from the Windows Apps menu or through Linux Applications menu (see Figure 3.5).When StackBuilder Plus opens, follow the onscreen instructions, selecting the EnterpriseDB Connectors option from the Database Drivers node of the tree control (see Figure 3.6).