The OSS supported by Fujitsu Enterprise Postgres is listed below.
OSS name | Version | Platform | Description | Reference | |
|---|---|---|---|---|---|
Linux | Windows | ||||
PostgreSQL | 17.0 | Y | Y | Database management system | PostgreSQL Documentation |
orafce | 4.13.4 | Y | Y | Oracle-compatible SQL features | "Compatibility with Oracle Databases" in the Application Development Guide |
Pgpool-II | 4.5.4 | Y | N | Failover, connection pooling, load balancing, etc. | "Pgpool-II" in the Installation and Setup Guide for Server |
oracle_fdw | 2.7.0 | Y | Y | Connection to the Oracle database server | "oracle_fdw" in the Installation and Setup Guide for Server |
pg_statsinfo | 16.0 | Y | N | Collection and accumulation of statistics | "pg_statsinfo" in the Installation and Setup Guide for Server |
pg_hint_plan | 17.1.7.0 | Y | Y | Tuning (statistics management, query tuning) |
|
pg_dbms_stats | 14.0 | Y | Y |
| |
pg_repack | 1.5.1 | Y | N | Table reorganization | "pg_repack" in the Installation and Setup Guide for Server |
pg_rman | 1.3.16 | Y | N | Backup and restore management | "pg_rman" in the Installation and Setup Guide for Server |
pgBackRest | 2.53.1 | Y | N | "pgBackRest" in the Installation and Setup Guide for Server | |
pgAdmin4 | 8.12 | N | Y | Operation and development GUI | Operation Guide |
pgBadger | 12.4 | Y | N | Log analysis | "pgBadger" in the Installation and Setup Guide for Server |
pg_bigm | 1.2-20240606 | Y | N | Full-text search (multibyte) | "pg_bigm" in the Installation and Setup Guide for Server |
ldap2pg | 6.1 | Y | N | Managing user |
|
PostgreSQL JDBC driver | 42.7.4 | Y | Y | JDBC driver | "JDBC Driver" in the Application Development Guide |
psqlODBC | 17.00.0001 | Y | Y | ODBC driver | "ODBC Driver" in the Application Development Guide |
Npgsql | 8.0.4 | Y | Y | .NET data provider | ".NET Data Provider" in the Application Development Guide |
pgvector | 0.7.4 | Y | Y | Vector data storage, operation, and search | "pgvector" in the Installation and Setup Guide for Server |
PostGIS | 3.4.3 | L | N | Geographic information system extension | PostGIS Build Instructions |
Y: Supported
L: Limited support
N: Not supported
*1: Server mode is not supported.
*2: In order for Npgsql to operate, an .NET provided by Microsoft is required, but check the support version of the provider for the OS version on which .NET can operate.
*3: It does not provide the ability to generate vector data. If you want to identify relationships and similarities between text, images, audio, and other data, use software or services that generate vector data and store the generated vector data in a database.
The manual may refer to pgvector documentation. Refer to the documents published at the following site:
https://github.com/pgvector/pgvector/blob/v0.7.4/README.md
*4: OSS is not included in the Fujitsu Enterprise Postgres program and does not provide a fix. Therefore, you should refer to the PostGIS Build Instructions and download the required OSS.
The PostGIS Build Instructions will be updated once a version with new fixes is released by the community and verified by Fujitsu. A revision of the PostGIS Build Instructions will be notified when the fix for server feature is provided. Build according to the updated PostGIS Build Instructions to take advantage of the new modified version.
*5: Refer to the PostGIS Build Instructions to complete the build and setup. The PostGIS Build Instructions can be obtained from the following site:
https://www.postgresql.fastware.com/knowledge-base/how-to/installing-postgis
