Available native packages v17
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. At the 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 | Installed by default | Package installs |
|---|---|---|
| edb-as16-server | Yes | Installs core components of the EDB Postgres Advanced Server database server. |
| edb-as16-server-client | Yes | Client programs and utilities that you can use to access and manage EDB Postgres Advanced Server. |
| edb-as16-server-contrib | Yes | Installs contributed tools and utilities that are distributed with EDB Postgres Advanced Server. Files for these modules are installed in: Documentation: /usr/edb/as16/share/docLoadable modules: /usr/edb/as16/libBinaries: /usr/edb/as16/bin |
| edb-as16-server-core | Yes | Includes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database. |
| edb-as16-server-devel | Yes | 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-as16-server-docs | Yes | Installs the readme file. |
| edb-as16-server-edb-modules | No | Installs supporting modules for EDB Postgres Advanced Server. |
| edb-as16-server-libs | Yes | Provides the essential shared libraries for any EDB Postgres Advanced Server client program or interface. |
| edb-as16-server-llvmjit | No | Contains support for just-in-time (JIT) compiling parts of EDB Postgres Advanced Server's queries. You need to install this package separately. |
| edb-as16-server-pldebugger | No | Implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server. |
| edb-as16-server-plperl | Yes | Installs the PL/Perl procedural language for EDB Postgres Advanced Server. The edb-as16-server-plperl package depends on the platform-supplied version of Perl. |
| edb-as16-server-plpython3 | Yes | 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-as16-server-pltcl | Yes | Installs the PL/Tcl procedural language for EDB Postgres Advanced Server. The edb-as16-server-pltcl package depends on the platform-supplied version of TCL. |
| edb-as16-server-sqlprofiler | No | Installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code. |
| edb-as16-server-sqlprotect | Yes | Installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks. |
| edb-as16-server-sslutils | No | Installs functionality that provides SSL support. |
| edb-as16-server-cloneschema | No | Installs the EDB Clone Schema extension. For more information about EDB Clone Schema, see EDB clone schema. |
| edb-as16-server-parallel-clone | No | Installs functionality that supports the EDB Clone Schema extension. |
| edb-as16-pgagent | No | 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-as16-edbplus | No | 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-as16-pgpool44-extensions | No | Creates pgPool extensions required by the server for use with pgpool. |
| edb-as16-postgis34 | No | Installs POSTGIS meta RPMs. |
| edb-as16-postgis34-core | No | 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-as16-postgis34-docs | No | Installs PDF documentation of PostGIS. |
| edb-as16-postgis34-utils | No | Installs the utilities for PostGIS. |
| edb-as16-postgis34-gui | No | Provides a GUI for PostGIS. |
| edb-as16-libicu | No | Contains the supporting library files. |
| edb-as16-hdfs-fdw | No | 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-as16-hdfs-fdw-doc | No | Documentation for the Hadoop Data Adapter. |
| edb-as16-mongo-fdw | No | EDB Postgres Advanced Server extension that implements a foreign data wrapper for MongoDB. |
| edb-as16-mongo-fdw-doc | No | Documentation for the foreign data wrapper for MongoDB. |
| edb-as16-mysql-fdw | No | EDB Postgres Advanced Server extension that implements a foreign data wrapper for MySQL. |
The following table lists the packages for EDB Postgres Advanced Server supporting components.
| Package name | Package installs |
|---|---|
| edb-pgpool44 | 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 isn't 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're developing C/C++ applications that require these files. |
| edb-odbc | Installs the driver needed for applications to access an EDB Postgres Advanced Server system by way of ODBC. |
| edb-odbc-devel | Installs the ODBC include files. Install this package if you're developing C/C++ applications that require these files. |
| edb-pgbouncer121 | 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 the management tool that efficiently manages, monitors, and tunes 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. |
| pgadmin4 | Installs all required components to run pgadmin4 in desktop and web modes. Pgadmin4 is a management tool for Postgres capable of hosting the Python application and presenting it to the user as a desktop application. |
| pgadmin4-desktop | Installs pgadmin4 for desktop mode only. |
| pgadmin4-web | Installs pgadmin4 for web mode only. |
| pgadmin4-server | Installs pgadmin4's core server 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. |
| edb-rs | A Java-based replication framework that provides asynchronous replication across Postgres and EDB Postgres Advanced Server database servers. It supports primary-standby, primary-primary, and hybrid configurations. |
| edb-rs-client | A Java-based command-line tool that's used to configure and operate a replication network by way of 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, EDB Postgres Advanced Server, 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 EDB Postgres Advanced Server 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 Postgres Advanced Server 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. At the command line, assume superuser privileges, and enter:
apt list edb*
Note
The available package list is subject to change.
| Package name | Installed by default | Package installs |
|---|---|---|
| edb-as16-server | Yes | Installs core components of the EDB Postgres Advanced Server database server. |
| edb-as16-server-client | Yes | Includes client programs and utilities that you can use to access and manage EDB Postgres Advanced Server. |
| edb-as16-server-core | Yes | Includes the programs needed to create the core functionality behind the EDB Postgres Advanced Server database. |
| edb-as16-server-dev | Yes | 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-as16-server-doc | Yes | Installs the readme file. |
| edb-as16-server-edb-modules | No | Installs supporting modules for EDB Postgres Advanced Server. |
| edb-as16-server-pldebugger | No | Implements an API for debugging PL/pgSQL functions on EDB Postgres Advanced Server. |
| edb-as16-server-plpython3 | Yes | Installs the PL/Python procedural language for EDB Postgres Advanced Server. PL/Python2 support is not available for EDB Postgres Advanced Server version 15 and later. |
| edb-as16-server-pltcl | Yes | Installs the PL/Tcl procedural language for EDB Postgres Advanced Server. The edb-as16-server-pltcl package depends on the platform-supplied version of TCL. |
| edb-as16-server-sqlprofiler | No | Installs EDB Postgres Advanced Server's SQL Profiler feature. SQL Profiler helps identify and optimize SQL code. |
| edb-as16-server-sqlprotect | Yes | Installs EDB Postgres Advanced Server's SQL Protect feature. SQL Protect provides protection against SQL injection attacks. |
| edb-as16-server-sslutils | No | Installs functionality that provides SSL support. |
| edb-as16-server-cloneschema | No | Installs the EDB Clone Schema extension. For more information about EDB Clone Schema, see EDB Clone Schema. |
| edb-as16-server-parallel-clone | No | Installs functionality that supports the EDB Clone Schema extension. |
| edb-as16-edbplus | No | Contains the files required to install the EDB*Plus command-line client. EDB*Plus commands are compatible with Oracle's SQL*Plus. |
| edb-as16-pgadmin4 | No | pgAdmin 4 provides a graphical management interface for EDB Postgres Advanced Server and PostgreSQL databases. |
| edb-as16-pgadmin-apache | No | Apache support module for pgAdmin 4. |
| edb-as16-pgadmin4-common | No | pgAdmin 4 supporting files. |
| edb-as16-pgadmin4-doc | No | pgAdmin 4 documentation module. |
| edb-as16-pgpool44-extensions | No | Creates pgPool extensions required by the server. |
| edb-as16-postgis34 | No | Installs POSTGIS support for geospatial data. |
| edb-as16-postgis34-scripts | No | Installs POSTGIS support for geospatial data. |
| edb-as16-postgis34-doc | No | Provides support for POSTGIS. |
| edb-as16-postgis34-gui | No | Provides a GUI for POSTGIS. |
| edb-as16-postgis-scripts | No | Provides support for POSTGIS. |
| edb-as16-pgagent | No | Installs pgAgent, a job scheduler for EDB Postgres Advanced Server. Before installing this package, you must install the EPEL repository. For detailed information about installing EPEL, see Linux installation troubleshooting. |
| edb-as16-hdfs-fdw | No | 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-as16-hdfs-fdw-doc | No | Documentation for the Hadoop Data Adapter. |
| edb-as16-mongo-fdw | No | EDB Postgres Advanced Server extension that implements a foreign data wrapper for MongoDB. |
| edb-as16-mongo-fdw-doc | No | Documentation for the foreign data wrapper for MongoDB. |
| edb-as16-mysql-fdw | No | EDB Postgres Advanced Server extension that implements a foreign data wrapper for MySQL. |
| edb-pgpool44 | No | 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 isn't supported on Windows systems. |
| edb-jdbc | No | Includes the .jar files needed for Java programs to access an EDB Postgres Advanced Server database. |
| edb-migrationtoolkit | No | Installs Migration Toolkit, facilitating migration to an EDB Postgres Advanced Server database from Oracle, PostgreSQL, MySQL, Sybase, and SQL Server. |
| edb-pgbouncer121 | No | PgBouncer, a lightweight connection pooler. This package requires the libevent package. |
| edb-efm40 | No | Installs EDB Failover Manager, which adds fault tolerance to database clusters to minimize downtime when a primary database fails by keeping data online in high availability configurations. |