Available native packages v15
EDB provides a number of native packages in the EDB repository. The packages vary slightly for the various Linux variations. See:
RHEL/OL/Rocky Linux/AlmaLinux/CentOS/SLES Packages
EDB Postgres Advanced Server RPM packages
The tables that follow list the RPM packages that are available from EDB. You can also use the yum search or dnf search command to access a list of the packages that are currently available from your configured repository. Open a command line, assume superuser privileges, and enter:
On RHEL or CentOS 7:
yum search <package>
On RHEL or Rocky Linux or AlmaLinux 8:
dnf search <package>
Where package is the search term that specifies the name (or partial name) of a package.
Note: The available package list is subject to change.
| Package name | Package installs |
|---|---|
| edb-as15-server | Installs core components of the EDB Postgres Advanced Server database server. |
| edb-as15-server-client | Client programs and utilities that you can use to access and manage EDB Postgres Advanced Server. |
| edb-as15-server-contrib | Installs contributed tools and utilities that are distributed with EDB Postgres Advanced Server. Files for these modules are installed in: Documentation: /usr/edb/as15/share/docLoadable modules: /usr/edb/as15/libBinaries: /usr/edb/as15/bin |
| edb-as15-server-core | Includes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database. |
| edb-as15-server-devel | Installs the header files and libraries needed to compile C or C++ applications that directly interact with an EDB Postgres Advanced Server server and the ecpg or ecpgPlus C preprocessor. |
| edb-as15-server-docs | Installs the readme file. |
| edb-as15-server-edb-modules | Installs supporting modules for EDB Postgres Advanced Server. |
| edb-as15-server-indexadvisor | Installs EDB Postgres Advanced Server's Index Advisor feature. The Index Advisor utility helps to determine the columns to index to improve performance in a given workload. |
| edb-as15-server-libs | Provides the essential shared libraries for any EDB Postgres Advanced Server client program or interface. |
| edb-as15-server-llvmjit | Contains support for just-in-time (JIT) compiling parts of EDB Postgres Advanced Server's queries. You need to install this package separately. |
| edb-as15-server-pldebugger | Implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server. |
| edb-as15-server-plperl | Installs the PL/Perl procedural language for EDB Postgres Advanced Server. The edb-as15-server-plperl package depends on the platform-supplied version of Perl. |
| edb-as15-server-plpython3 | Installs the PL/Python procedural language for EDB Postgres Advanced Server. The PL/Python2 support is no longer available in EDB Postgres Advanced Server version 15 and later. |
| edb-as15-server-pltcl | Installs the PL/Tcl procedural language for EDB Postgres Advanced Server. The edb-as15-pltcl package depends on the platform-supplied version of TCL. |
| edb-as15-server-sqlprofiler | Installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code. |
| edb-as15-server-sqlprotect | Installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks. |
| edb-as15-server-sslutils | Installs functionality that provides SSL support. |
| edb-as15-server-cloneschema | Installs the EDB Clone Schema extension. For more information about EDB Clone Schema, see EDB clone schema. |
| edb-as15-server-parallel-clone | Installs functionality that supports the EDB Clone Schema extension. |
| edb-as15-pgagent | Installs pgAgent: Installs pgAgent, a job scheduler for EDB Postgres Advanced Server. Before installing this package, you must install EPEL repository. For detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as15-edbplus | The edb-edbplus package contains the files required to install the EDB*Plus command line client. EDB*Plus commands are compatible with Oracle's SQL*Plus. |
| edb-as15-pgsnmpd | Simple Network Management Protocol (SNMP) is a protocol that allows you to supervise an apparatus connected to the network. |
| edb-as15-pgpool41-extensions | Creates pgPool extensions required by the server for use with pgpool. |
| edb-as15-postgis3 | Installs POSTGIS meta RPMs. |
| edb-as15-postgis3-core | Provides support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. |
| edb-as15-postgis3-docs | Installs pdf documentation of PostGIS. |
| edb-as15-postgis-jdbc | Installs the essential jdbc driver for PostGIS. |
| edb-as15-postgis3-utils | Installs the utilities for PostGIS. |
| edb-as15-postgis3-gui | Provides a GUI for PostGIS. |
| edb-as15-slony-replication | Installs the meta RPM for Slony-I. |
| edb-as15-slony-replication-core | Slony-I builds a primary-standby system that includes all features and capabilities needed to replicate large databases to a reasonably limited number of standby systems. |
| edb-as15-slony-replication-docs | Contains the Slony project documentation in pdf form. |
| edb-as15-slony-replication-tools | Contains the Slony altperl tools and utilities that are useful when deploying Slony replication environments. Before installing this package, you must install EPEL repository. For detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as15-libicu | Contains the supporting library files. |
The following table lists the packages for EDB Postgres Advanced Server 15 supporting components.
| Package name | Package installs |
|---|---|
| edb-pgpool41 | Contains the pgPool-II installer. The pgpool-II utility package acts as a middleman between client applications and Server database servers. pgpool-II functionality is transparent to client applications; client applications connect to pgpool-II instead of directly to EDB Postgres Advanced Server, and pgpool-II manages the connection. EDB supports the following pgpool-II features: - Load balancing - Connection pooling - High availability - Connection limits pgpool-II runs as a service on Linux systems, and is not supported on Windows systems. |
| edb-jdbc | The edb-jdbc package includes the .jar files needed for Java programs to access an EDB Postgres Advanced Server database. |
| edb-migrationtoolkit | The edb-migrationtoolkit package installs Migration Toolkit, facilitating migration to an EDB Postgres Advanced Server database from Oracle, PostgreSQL, MySQL, Sybase and SQL Server. |
| edb-oci | The edb-oci package installs the EDB Open Client library, allowing applications that use the Oracle Call Interface API to connect to an EDB Postgres Advanced Server database. |
| edb-oci-devel | Installs the OCI include files; install this package if you are developing C/C++ applications that require these files. |
| edb-odbc | Installs the driver needed for applications to access an EDB Postgres Advanced Server system via ODBC. |
| edb-odbc-devel | Installs the ODBC include files; install this package if you are developing C/C++ applications that require these files. |
| edb-pgbouncer115 | Contains PgBouncer (a lightweight connection pooler). This package requires the libevent package. |
| ppas-xdb | Contains the xDB installer; xDB provides asynchronous cross-database replication. |
| ppas-xdb-console | Provides support for xDB. |
| ppas-xdb-libs | Provides support for xDB. |
| ppas-xdb-publisher | Provides support for xDB. |
| ppas-xdb-subscriber | Provides support for xDB. |
| edb-pem | The edb-pem package installs Management Tool that efficiently manages, monitor, and tune large Postgres deployments from a single remote GUI console. |
| edb-pem-agent | The edb-pem-agent is an agent component of Postgres Enterprise Manager. |
| edb-pem-docs | Contains documentation for various languages, which are in HTML format. |
| edb-pem-server | Contains server components of Postgres Enterprise Manager. |
| edb-pgadmin4 | A management tool for PostgreSQL capable of hosting the Python application and presenting it to the user as a desktop application. |
| edb-pgadmin4-desktop-common | Installs the desktop components of pgAdmin4 for all window managers. |
| edb-pgadmin4-desktop-gnome | Installs the gnome desktop components of pgAdmin4 |
| edb-pgadmin4-docs | Contains documentation of pgAdmin4. |
| edb-pgadmin4-web | Contains the required files to run pgAdmin4 as a web application. |
| edb-efm40 | Installs EDB Failover Manager that adds fault tolerance to database clusters to minimize downtime when a primary database fails by keeping data online in high availability configurations. |
| edb-rs | A Java-based replication framework that provides asynchronous replication across Postgres and EPAS database servers. It supports primary-standby, primary-primary, and hybrid configurations. |
| edb-rs-client | A Java-based command-line tool that is used to configure and operate a replication network via different commands by interacting with the EPRS server. |
| edb-rs-datavalidator | A Java-based command-line tool that provides row and column level data comparison of a source and target database table. The supported RDBMS servers include PostgreSQL, EPAS, Oracle, and MS SQL Server. |
| edb-rs-libs | Contains certain libraries that are commonly used by ERPS Server, EPRS Client, and Monitoring modules. |
| edb-rs-monitor | A Java-based application that provides monitoring capabilities to ensure a smooth functioning of the EPRS replication cluster. |
| edb-rs-server | A Java-based replication framework that provides asynchronous replication across Postgres and EPAS database servers. It supports primary-standby, primary-primary, and hybrid configurations. |
| edb-bart | Installs the Backup and Recovery Tool (BART) to support online backup and recovery across local and remote PostgreSQL and EDB EDB Postgres Advanced Servers. |
| libevent-edb | Contains supporting library files. |
| libiconv-edb | Contains supporting library files. |
| libevent-edb-devel | Contains supporting library files. |
Debian/Ubuntu Packages
EDB Postgres Advanced Server Debian packages
The table lists some of the Debian packages that are available from EDB. You can also use the apt list command to access a list of the packages that are currently available from your configured repository. Open a command line, assume superuser privileges, and enter:
apt list edb*
Note
The available package list is subject to change.
| Package name | Package installs |
|---|---|
| edb-as15-server | Installs core components of the EDB Postgres Advanced Server database server. |
| edb-as15-server-client | Includes client programs and utilities that you can use to access and manage EDB Postgres Advanced Server. |
| edb-as15-server-core | Includes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database. |
| edb-as15-server-dev | Package that contains the header files and libraries needed to compile C or C++ applications that directly interact with an EDB Postgres Advanced Server server and the ecpg or ecpgPlus C preprocessor. |
| edb-as15-server-doc | Installs the readme file. |
| edb-as15-server-edb-modules | Installs supporting modules for EDB Postgres Advanced Server. |
| edb-as15-server-indexadvisor | Installs EDB Postgres Advanced Server's Index Advisor feature. The Index Advisor utility helps to determine the columns to index to improve performance in a given workload. |
| edb-as15-server-pldebugger | This package implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server. |
| edb-as15-server-plpython3 | Installs the PL/Python procedural language for EDB Postgres Advanced Server. PL/Python2 support is no longer available from EDB Postgres Advanced Server version 15 onwards. |
| edb-as15-server-pltcl | Installs the PL/Tcl procedural language for EDB Postgres Advanced Server. The edb-as15-pltcl package depends on the platform-supplied version of TCL. |
| edb-as15-server-sqlprofiler | Installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code. |
| edb-as15-server-sqlprotect | Installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks. |
| edb-as15-server-sslutils | Installs functionality that provides SSL support. |
| edb-as15-server-cloneschema | Installs the EDB Clone Schema extension. For more information about EDB Clone Schema, see the EDB clone schema. |
| edb-as15-server-parallel-clone | Installs functionality that supports the EDB Clone Schema extension. |
| edb-as15-edbplus | The edb-edbplus package contains the files required to install the EDB*Plus command line client. EDB*Plus commands are compatible with Oracle's SQL*Plus. |
| edb-as15-pgsnmpd | Simple Network Management Protocol (SNMP) is a protocol that allows you to supervise an apparatus connected to the network. |
| edb-as15-pgadmin4 | pgAdmin 4 provides a graphical management interface for EDB Postgres Advanced Server and PostgreSQL databases. |
| edb-as15-pgadmin-apache | Apache support module for pgAdmin 4. |
| edb-as15-pgadmin4-common | pgAdmin 4 supporting files. |
| edb-as15-pgadmin4-doc | pgAdmin 4 documentation module. |
| edb-as15-pgpool41-extensions | Creates pgPool extensions required by the server. |
| edb-as15-postgis3 | Installs POSTGIS support for geospatial data. |
| edb-as15-postgis3-scripts | Installs POSTGIS support for geospatial data. |
| edb-as15-postgis3-doc | Provides support for POSTGIS. |
| edb-as15-postgis3-gui | Provides a GUI for POSTGIS. |
| edb-as15-postgis-jdbc | Provides support for POSTGIS. |
| edb-as15-postgis-scripts | Provides support for POSTGIS. |
| edb-as15-pgagent | Installs pgAgent, a job scheduler for EDB Postgres Advanced Server. Before installing this package, you must install EPEL repository. For detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as15-slony-replication | Installs the meta RPM for Slony-I. |
| edb-as15-slony-replication-core | Contains core portions of Slony-I to build a primary-standby system that includes all features and capabilities needed to replicate large databases to a reasonably limited number of standby systems. |
| edb-as15-slony-replication-docs | Contains the Slony project documentation in pdf form. |
| edb-as15-slony-replication-tools | Contains the Slony altperl tools and utilities that are useful when deploying Slony replication environments. Before installing this package, you must install EPEL repository. For detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as15-hdfs-fdw | The Hadoop Data Adapter allows you to query and join data from Hadoop environments with your Postgres or EDB Postgres Advanced Server instances. It's YARN Ready certified with HortonWorks and provides optimizations for performance with predicate pushdown support. |
| edb-as15-hdfs-fdw-doc | Documentation for the Hadoop Data Adapter. |
| edb-as15-mongo-fdw | This EDB Postgres Advanced Server extension implements a foreign data wrapper for MongoDB. |
| edb-as15-mongo-fdw-doc | Documentation for the foreign data wrapper for MongoDB. |
| edb-as15-mysql-fdw | This EDB Postgres Advanced Server extension implements a foreign data wrapper for MySQL. |
| edb-pgpool41 | Contains the pgPool-II installer. The pgpool-II utility package acts as a middleman between client applications and Server database servers. pgpool-II functionality is transparent to client applications; client applications connect to pgpool-II instead of directly to EDB Postgres Advanced Server, and pgpool-II manages the connection. EDB supports the following pgpool-II features: - Load balancing - Connection pooling - High availability - Connection limits pgpool-II runs as a service on Linux systems, and is not supported on Windows systems. |
| edb-jdbc | Includes the .jar files needed for Java programs to access an EDB Postgres Advanced Server database. |
| edb-migrationtoolkit | Installs Migration Toolkit, facilitating migration to an EDB Postgres Advanced Server database from Oracle, PostgreSQL, MySQL, Sybase and SQL Server. |
| edb-pgbouncer115 | PgBouncer, a lightweight connection pooler. This package requires the libevent package. |
| edb-efm40 | Installs EDB Failover Manager that adds fault tolerance to database clusters to minimize downtime when a primary database fails by keeping data online in high availability configurations. |
Updating an RPM installation
If you have an existing EDB Postgres Advanced Server RPM installation, you can use yum or dnf to upgrade your repository configuration file and update to a more recent product version. To update the edb.repo file, assume superuser privileges and enter:
On RHEL or CentOS 7:
yum upgrade edb-repo
On RHEL or Rocky Linux or AlmaLinux 8:
dnf upgrade edb-repo
yum or dnf updates the edb.repo file to enable access to the current EDB repository, configured to connect with the credentials specified in your edb.repo file. Then, you can use yum or dnf to upgrade all packages whose names include the expression edb:
On RHEL or CentOS 7:
yum upgrade edb*
On RHEL or Rocky Linux or AlmaLinux 8:
dnf upgrade edb*
Note
The yum upgrade or dnf upgrade commands perform an update only between minor releases. To update between major releases, use pg_upgrade.
For more information about using yum commands and options, enter yum --help on your command line.
For more information about using dnf commands and options, see the dnf documentation.