Available native packages v12
EDB provides a number of native packages in the EDB repository. The packages vary slightly for the various Linux variations, see:
RHEL/Rocky Linux/AlmaLinux/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 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 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-as12-server | This package installs core components of the EDB Postgres Advanced Server database server. |
| edb-as12-server-client | Client programs and utilities that you can use to access and manage EDB Postgres Advanced Server. |
| edb-as12-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/as12/share/docLoadable modules: /usr/edb/as12/libBinaries: /usr/edb/as12/bin |
| edb-as12-server-core | Includes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database. |
| edb-as12-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-as12-server-docs | Installs the readme file. |
| edb-as12-server-edb-modules | Installs supporting modules for EDB Postgres Advanced Server |
| edb-as12-server-indexadvisor | Installs EDB Postgres Advanced Server's Index Advisor feature. The Index Advisor utility helps determine which columns you should index to improve performance in a given workload. |
| edb-as12-server-libs | Provides the essential shared libraries for any EDB Postgres Advanced Server client program or interface. |
| edb-as12-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-as12-server-pldebugger | This package implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server. |
| edb-as12-server-plperl | Installs the PL/Perl procedural language for EDB Postgres Advanced Server. The edb-as12-server-plperl package is dependent on the platform-supplied version of Perl. |
| edb-as12-server-plpython3 | Installs the PL/Python procedural language for EDB Postgres Advanced Server. The PL/Python2 support is no longer available from EDB Postgres Advanced Server version 12 onwards. |
| edb-as12-server-pltcl | Installs the PL/Tcl procedural language for EDB Postgres Advanced Server. The edb-as12-pltcl package is dependent on the platform-supplied version of TCL. |
| edb-as12-server-sqlprofiler | This package installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code. |
| edb-as12-server-sqlprotect | This package installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks. |
| edb-as12-server-sslutils | This package installs functionality that provides SSL support. |
| edb-as12-server-cloneschema | This package installs the EDB Clone Schema extension. For more information about EDB Clone Schema, see the EDB Postgres Advanced Server Guide. |
| edb-as12-server-parallel-clone | This package installs functionality that supports the EDB Clone Schema extension. |
| edb-as12-pgagent | Installs pgAgent; pgAgent is a job scheduler for EDB Postgres Advanced Server. Before installing this package, you must install EPEL; for detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as12-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-as12-pgsnmpd | SNMP (Simple Network Management Protocol) is a protocol that allows you to supervise an apparatus connected to the network. |
| edb-as12-pgpool41-extensions | This package creates pgPool extensions required by the server for use with pgpool. |
| edb-as12-postgis3 | Installs POSTGIS meta RPMs. |
| edb-as12-postgis3-core | This package 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-as12-postgis3-docs | This package installs pdf documentation of PostGIS. |
| edb-as12-postgis-jdbc | This package installs the essential jdbc driver for PostGIS. |
| edb-as12-postgis3-utils | This package installs the utilities for PostGIS. |
| edb-as12-postgis3-gui | This package provides a GUI for PostGIS. |
| edb-as12-slony-replication | Installs the meta RPM for Slony-I. |
| edb-as12-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-as12-slony-replication-docs | This package contains the Slony project documentation (in pdf form). |
| edb-as12-slony-replication-tools | This package contains the Slony altperl tools and utilities that are useful when deploying Slony replication environments. Before installing this package, you must install EPEL; for detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as12-libicu | These packages contain supporting library files. |
The following table lists the packages for EDB Postgres Advanced Server 12 supporting components.
| Package name | Package installs |
|---|---|
| edb-pgpool41 | This package 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 | This package installs the OCI include files; install this package if you are developing C/C++ applications that require these files. |
| edb-odbc | This package installs the driver needed for applications to access an EDB Postgres Advanced Server system via ODBC. |
| edb-odbc-devel | This package installs the ODBC include files; install this package if you are developing C/C++ applications that require these files. |
| edb-pgbouncer112 | This package contains PgBouncer (a lightweight connection pooler). This package requires the libevent package. |
| ppas-xdb | This package contains the xDB installer; xDB provides asynchronous cross-database replication. |
| ppas-xdb-console | This package provides support for xDB. |
| ppas-xdb-libs | This package provides support for xDB. |
| ppas-xdb-publisher | This package provides support for xDB. |
| ppas-xdb-subscriber | This package 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 | This package is an agent component of Postgres Enterprise Manager. |
| edb-pem-docs | This package contains documentation for various languages, which are in HTML format. |
| edb-pem-server | This package contains server components of Postgres Enterprise Manager. |
| edb-pgadmin4 | This package is 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 | This package installs the desktop components of pgAdmin4 for all window managers. |
| edb-pgadmin4-desktop-gnome | This package installs the gnome desktop components of pgAdmin4 |
| edb-pgadmin4-docs | This package contains documentation of pgAdmin4. |
| edb-pgadmin4-web | This package contains the required files to run pgAdmin4 as a web application. |
| edb-efm40 | This package 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 | This package is 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 | This package is 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 | This package is 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 | This package contains certain libraries that are commonly used by ERPS Server, EPRS Client, and Monitoring modules. |
| edb-rs-monitor | This package is a java-based application that provides monitoring capabilities to ensure a smooth functioning of the EPRS replication cluster. |
| edb-rs-server | This package is 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 | This package 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 | This package contains supporting library files. |
| libiconv-edb | This package contains supporting library files. |
| libevent-edb-devel | This package contains supporting library files. |
Debian/Ubuntu Packages
EDB Postgres Advanced Server Debian packages
The table that follows 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-as12-server | Installs core components of the EDB Postgres Advanced Server database server. |
| edb-as12-server-client | Includes client programs and utilities that you can use to access and manage EDB Postgres Advanced Server. |
| edb-as12-server-core | Includes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database. |
| edb-as12-server-dev | The edb-as12-server-dev package 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-as12-server-doc | Installs the readme file. |
| edb-as12-server-edb-modules | Installs supporting modules for EDB Postgres Advanced Server. |
| edb-as12-server-indexadvisor | Installs EDB Postgres Advanced Server's Index Advisor feature. The Index Advisor utility helps determine which columns you should index to improve performance in a given workload. |
| edb-as12-server-pldebugger | This package implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server. |
| edb-as12-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 12 onwards. |
| edb-as12-server-pltcl | Installs the PL/Tcl procedural language for EDB Postgres Advanced Server. The edb-as12-pltcl package is dependent on the platform-supplied version of TCL. |
| edb-as12-server-sqlprofiler | This package installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code. |
| edb-as12-server-sqlprotect | This package installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks. |
| edb-as12-server-sslutils | This package installs functionality that provides SSL support. |
| edb-as12-server-cloneschema | This package installs the EDB Clone Schema extension. For more information about EDB Clone Schema, see the EDB Postgres Advanced Server Guide. |
| edb-as12-server-parallel-clone | This package installs functionality that supports the EDB Clone Schema extension. |
| edb-as12-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-as12-pgsnmpd | SNMP (Simple Network Management Protocol) is a protocol that allows you to supervise an apparatus connected to the network. |
| edb-as12-pgadmin4 | pgAdmin 4 provides a graphical management interface for EDB Postgres Advanced Server and PostgreSQL databases. |
| edb-as12-pgadmin-apache | Apache support module for pgAdmin 4. |
| edb-as12-pgadmin4-common | pgAdmin 4 supporting files. |
| edb-as12-pgadmin4-doc | pgAdmin 4 documentation module. |
| edb-as12-pgpool41-extensions | This package creates pgPool extensions required by the server. |
| edb-as12-postgis3 | This package installs POSTGIS support for geospatial data. |
| edb-as12-postgis3-scripts | This package installs POSTGIS support for geospatial data. |
| edb-as12-postgis3-doc | This package provides support for POSTGIS. |
| edb-as12-postgis3-gui | This package provides a GUI for POSTGIS. |
| edb-as12-postgis-jdbc | This package provides support for POSTGIS. |
| edb-as12-postgis-scripts | This package provides support for POSTGIS. |
| edb-as12-pgagent | This package installs pgAgent; pgAgent is a job scheduler for EDB Postgres Advanced Server. Before installing this package, you must install EPEL; for detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as12-slony-replication | This package installs the meta RPM for Slony-I. |
| edb-as12-slony-replication-core | This package 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-as12-slony-replication-docs | This package contains the Slony project documentation (in pdf form). |
| edb-as12-slony-replication-tools | This package contains the Slony altperl tools and utilities that are useful when deploying Slony replication environments. Before installing this package, you must install EPEL; for detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as12-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 is YARN Ready certified with HortonWorks, and provides optimizations for performance with predicate pushdown support. |
| edb-as12-hdfs-fdw-doc | Documentation for the Hadoop Data Adapter. |
| edb-as12-mongo-fdw | This EDB EDB Postgres Advanced Server extension implements a Foreign Data Wrapper for MongoDB. |
| edb-as12-mongo-fdw-doc | Documentation for the Foreign Data Wrapper for MongoDB. |
| edb-as12-mysql-fdw | This EDB EDB Postgres Advanced Server extension implements a Foreign Data Wrapper for MySQL. |
| edb-pgpool41 | This package 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-pgbouncer112 | This package contains PgBouncer (a lightweight connection pooler). This package requires the libevent package. |
| edb-efm40 | This package 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:
```text dnf upgrade edb-repo ```
dnfupdates theedb.repofile to enable access to the current EDB repository, configured to connect with the credentials specified in youredb.repofile. Then, you can useyumordnfto upgrade all packages whose names include the expressionedb`:
```text dnf upgrade edb* ```
Note
The dnf upgrade command perform an update only between minor releases; to update between major releases, you must use pg_upgrade.
For more information about using yum commands and options, enter dnf --help on your command line.
For more information about using dnf commands and options, visit: