The OSS supported by Fujitsu Enterprise Postgres is listed below.
OSS name | Version | Platform | Description | Reference | |
|---|---|---|---|---|---|
Linux | Windows | ||||
PostgreSQL | 17.4 | Y | Y | Database management system | PostgreSQL Documentation |
orafce | 4.13.5 | Y | Y | Oracle-compatible SQL features | "Compatibility with Oracle Databases" in the Application Development Guide |
Pgpool-II | 4.5.5 | 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.54.1 | Y | N | "pgBackRest" in the Installation and Setup Guide for Server | |
pgAdmin4 | 8.14 | 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.2 | Y | N | Managing user |
|
PostgreSQL JDBC driver | 42.7.4 | Y | Y | JDBC driver | "JDBC Driver" in the Application Development Guide |
psqlODBC | 17.00.0004 | Y | Y | ODBC driver | "ODBC Driver" in the Application Development Guide |
Npgsql | 8.0.6 | Y | Y | .NET data provider | ".NET Data Provider" in the Application Development Guide |
psycopg | 3.2.4 | Y | Y | Python driver | "Python Language Package (psycopg)" 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 |
pgvectorscale | 0.5.1 | Y | N | Accelerating vector data search processing | "pgvectorscale" in the Installation and Setup Guide for Server |
Apache AGE | 1.5.0 | Y | N | Graph data storage and search | "Apache AGE" in the Installation and Setup Guide for Server |
pgai | extension-0.8.0 | Y | N | Vectorization of text data using external embedding model and declarative vectorization specification | Knowledge Data Management Feature User's Guide |
pg_cron | 1.6.5 | Y | N | SQL Job scheduler | "pg_cron" 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: pgvector by itself cannot generate vector data. pgai allows you to generate vector data for text data using an external embedded model. To use vector representations in other data formats, 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: The manual may refer to pgvectorscale documentation. Refer to the documents published at the following site:
https://github.com/timescale/pgvectorscale/blob/0.5.1/README.md
*5: The manual may refer to Apache AGE documentation. Refer to the documents published at the following site:
https://age.apache.org/age-manual/master/index.html
*6: The manual may refer to pgai documentation. Refer to the documents published at the following site:
https://github.com/timescale/pgai/blob/extension-0.8.0/README.md
*7: 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.
*8: 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
