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 namePackage installs
edb-as12-serverThis package installs core components of the EDB Postgres Advanced Server database server.
edb-as12-server-clientClient programs and utilities that you can use to access and manage EDB Postgres Advanced Server.
edb-as12-server-contribInstalls contributed tools and utilities that are distributed with EDB Postgres Advanced Server. Files for these modules are installed in:

Documentation: /usr/edb/as12/share/doc

Loadable modules: /usr/edb/as12/lib

Binaries: /usr/edb/as12/bin
edb-as12-server-coreIncludes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database.
edb-as12-server-develInstalls 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-docsInstalls the readme file.
edb-as12-server-edb-modulesInstalls supporting modules for EDB Postgres Advanced Server
edb-as12-server-indexadvisorInstalls 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-libsProvides the essential shared libraries for any EDB Postgres Advanced Server client program or interface.
edb-as12-server-llvmjitThis package contains support for Just in Time (JIT) compiling parts of EDBAS queries.
edb-as12-server-pldebuggerThis package implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server.
edb-as12-server-plperlInstalls 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-plpython3Installs 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-pltclInstalls 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-sqlprofilerThis package installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code.
edb-as12-server-sqlprotectThis package installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks.
edb-as12-server-sslutilsThis package installs functionality that provides SSL support.
edb-as12-server-cloneschemaThis 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-cloneThis package installs functionality that supports the EDB Clone Schema extension.
edb-as12-pgagentInstalls 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-edbplusThe 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-pgsnmpdSNMP (Simple Network Management Protocol) is a protocol that allows you to supervise an apparatus connected to the network.
edb-as12-pgpool41-extensionsThis package creates pgPool extensions required by the server for use with pgpool.
edb-as12-postgis3Installs POSTGIS meta RPMs.
edb-as12-postgis3-coreThis 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-docsThis package installs pdf documentation of PostGIS.
edb-as12-postgis-jdbcThis package installs the essential jdbc driver for PostGIS.
edb-as12-postgis3-utilsThis package installs the utilities for PostGIS.
edb-as12-postgis3-guiThis package provides a GUI for PostGIS.
edb-as12-slony-replicationInstalls the meta RPM for Slony-I.
edb-as12-slony-replication-coreSlony-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-docsThis package contains the Slony project documentation (in pdf form).
edb-as12-slony-replication-toolsThis 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-libicuThese packages contain supporting library files.

The following table lists the packages for EDB Postgres Advanced Server 12 supporting components.

Package namePackage installs
edb-pgpool41This 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-jdbcThe edb-jdbc package includes the .jar files needed for Java programs to access an EDB Postgres Advanced Server database.
edb-migrationtoolkitThe edb-migrationtoolkit package installs Migration Toolkit, facilitating migration to an EDB Postgres Advanced Server database from Oracle, PostgreSQL, MySQL, Sybase and SQL Server.
edb-ociThe 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-develThis package installs the OCI include files; install this package if you are developing C/C++ applications that require these files.
edb-odbcThis package installs the driver needed for applications to access an EDB Postgres Advanced Server system via ODBC.
edb-odbc-develThis package installs the ODBC include files; install this package if you are developing C/C++ applications that require these files.
edb-pgbouncer112This package contains PgBouncer (a lightweight connection pooler). This package requires the libevent package.
ppas-xdbThis package contains the xDB installer; xDB provides asynchronous cross-database replication.
ppas-xdb-consoleThis package provides support for xDB.
ppas-xdb-libsThis package provides support for xDB.
ppas-xdb-publisherThis package provides support for xDB.
ppas-xdb-subscriberThis package provides support for xDB.
edb-pemThe edb-pem package installs Management Tool that efficiently manages, monitor, and tune large Postgres deployments from a single remote GUI console.
edb-pem-agentThis package is an agent component of Postgres Enterprise Manager.
edb-pem-docsThis package contains documentation for various languages, which are in HTML format.
edb-pem-serverThis package contains server components of Postgres Enterprise Manager.
edb-pgadmin4This 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-commonThis package installs the desktop components of pgAdmin4 for all window managers.
edb-pgadmin4-desktop-gnomeThis package installs the gnome desktop components of pgAdmin4
edb-pgadmin4-docsThis package contains documentation of pgAdmin4.
edb-pgadmin4-webThis package contains the required files to run pgAdmin4 as a web application.
edb-efm40This 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-rsThis 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-clientThis 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-datavalidatorThis 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-libsThis package contains certain libraries that are commonly used by ERPS Server, EPRS Client, and Monitoring modules.
edb-rs-monitorThis package is a java-based application that provides monitoring capabilities to ensure a smooth functioning of the EPRS replication cluster.
edb-rs-serverThis 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-bartThis 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-edbThis package contains supporting library files.
libiconv-edbThis package contains supporting library files.
libevent-edb-develThis 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 namePackage installs
edb-as12-serverInstalls core components of the EDB Postgres Advanced Server database server.
edb-as12-server-clientIncludes client programs and utilities that you can use to access and manage EDB Postgres Advanced Server.
edb-as12-server-coreIncludes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database.
edb-as12-server-devThe 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-docInstalls the readme file.
edb-as12-server-edb-modulesInstalls supporting modules for EDB Postgres Advanced Server.
edb-as12-server-indexadvisorInstalls 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-pldebuggerThis package implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server.
edb-as12-server-plpython3Installs 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-pltclInstalls 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-sqlprofilerThis package installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code.
edb-as12-server-sqlprotectThis package installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks.
edb-as12-server-sslutilsThis package installs functionality that provides SSL support.
edb-as12-server-cloneschemaThis 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-cloneThis package installs functionality that supports the EDB Clone Schema extension.
edb-as12-edbplusThe 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-pgsnmpdSNMP (Simple Network Management Protocol) is a protocol that allows you to supervise an apparatus connected to the network.
edb-as12-pgadmin4pgAdmin 4 provides a graphical management interface for EDB Postgres Advanced Server and PostgreSQL databases.
edb-as12-pgadmin-apacheApache support module for pgAdmin 4.
edb-as12-pgadmin4-commonpgAdmin 4 supporting files.
edb-as12-pgadmin4-docpgAdmin 4 documentation module.
edb-as12-pgpool41-extensionsThis package creates pgPool extensions required by the server.
edb-as12-postgis3This package installs POSTGIS support for geospatial data.
edb-as12-postgis3-scriptsThis package installs POSTGIS support for geospatial data.
edb-as12-postgis3-docThis package provides support for POSTGIS.
edb-as12-postgis3-guiThis package provides a GUI for POSTGIS.
edb-as12-postgis-jdbcThis package provides support for POSTGIS.
edb-as12-postgis-scriptsThis package provides support for POSTGIS.
edb-as12-pgagentThis 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-replicationThis package installs the meta RPM for Slony-I.
edb-as12-slony-replication-coreThis 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-docsThis package contains the Slony project documentation (in pdf form).
edb-as12-slony-replication-toolsThis 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-fdwThe 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-docDocumentation for the Hadoop Data Adapter.
edb-as12-mongo-fdwThis EDB EDB Postgres Advanced Server extension implements a Foreign Data Wrapper for MongoDB.
edb-as12-mongo-fdw-docDocumentation for the Foreign Data Wrapper for MongoDB.
edb-as12-mysql-fdwThis EDB EDB Postgres Advanced Server extension implements a Foreign Data Wrapper for MySQL.
edb-pgpool41This 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-jdbcThe edb-jdbc package includes the .jar files needed for Java programs to access an EDB Postgres Advanced Server database.
edb-migrationtoolkitThe edb-migrationtoolkit package installs Migration Toolkit, facilitating migration to an EDB Postgres Advanced Server database from Oracle, PostgreSQL, MySQL, Sybase and SQL Server.
edb-pgbouncer112This package contains PgBouncer (a lightweight connection pooler). This package requires the libevent package.
edb-efm40This 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:

https://docs.fedoraproject.org/en-US/quick-docs/dnf/