Request for Support of PostgreSQL Plugins in Kubeblocks

[wallyxjh]

We compared the plugins supported by PostgreSQL on AWS and found that the PostgreSQL in Kubeblocks does not yet natively support the following plugins. We would appreciate it if these plugins could be considered for support. Thank you!

Missing Plugins and Corresponding Versions:

• address_standardizer - 3.5.2
• address_standardizer_data_us - 3.5.2
• amcheck - 1.3
• autoinc (contrib-spi) - 1.0
• auto_explain - Yes (built-in)
• bool_plperl - 1.0
• citext - 1.6
• dblink - 1.2
• earthdistance - 1.1
• flow_control - 1.0
• h3-pg - 1.34
• ICU module - 60.2
• intarray - 1.5
• ip4r - 2.4
• jsonb_plperl - 1.0
• log_fdw - 1.0
• mysql_fdw - 2.9
• moddatetime (contrib-spi) - 1.0
• oracle_fdw - 2.7.0
• orafce - 4.1
• pg_bigm - 1.2
• pg_buffercache - 1.3
• pg_freespacemap - 1.2
• pg_hint_plan - 1.4
• pg_proctab - 0.1
• pgactive - 2.1
• pgvector - 0.8.0
• plcoffee - 3.1.10
• plls - 3.1.10
• plperl - 1.0
• plv8 - 1.0
• PostGIS - 3.5.2
• postgis_tiger_geocoder - 3.5.2
• postgres_fdw - 1.1
• prefix - 1.2.10
• rdkit - 4.6.1
• rds_tools - 1.9
• refint (contrib-spi) - 1.0
• seg - 1.4
• sslinfo - 1.2
• tds_fdw - 2.0.4
• tsm_system_rows - 1.0
• tsm_system_time - 1.0
• uuid-ossp - 1.1
• wal2json - 2.6

[shanshanying]

Hi @wallyxjh

By Default KubeBlocks PG provides following plugins:

 address_standardizer
 address_standardizer-3
 address_standardizer_data_us
 address_standardizer_data_us-3
 adminpack
 amcheck
 autoinc
 bloom
 btree_gin
 btree_gist
 citext
 cube
 dblink
 decoderbufs
 dict_int
 dict_xsyn
 earthdistance
 extra_window_functions
 file_fdw
 first_last_agg
 fuzzystrmatch
 hll
 hstore
 hstore_pllua
 hstore_plluau
 hstore_plpython3u
 hypopg
 insert_username
 intagg
 intarray
 isn
 jsonb_plpython3u
 lo
 ltree
 ltree_plpython3u
 moddatetime
 old_snapshot
 pageinspect
 pg_auth_mon
 pg_buffercache
 pg_cron
 pg_dirtyread
 pg_freespacemap
 pg_mon
 pg_partman
 pg_permissions
 pg_prewarm
 pg_profile
 pg_repack
 pg_stat_kcache
 pg_stat_statements
 pg_surgery
 pg_tm_aux
 pg_trgm
 pg_visibility
 pgaudit
 pgcrypto
 pgl_ddl_deploy
 pglogical
 pglogical_origin
 pglogical_ticker
 pgq
 pgq_node
 pgrowlocks
 pgstattuple
 pldbgapi
 pllua
 plluau
 plpgsql
 plpgsql_check
 plprofiler
 plproxy
 plpython3u
 pltcl
 pltclu
 postgis
 postgis-3
 postgis_raster
 postgis_raster-3
 postgis_sfcgal
 postgis_sfcgal-3
 postgis_tiger_geocoder
 postgis_tiger_geocoder-3
 postgis_topology
 postgis_topology-3
 postgres_fdw
 refint
 seg
 set_user
 sslinfo
 tablefunc
 tcn
 timescaledb
 tsm_system_rows
 tsm_system_time
 unaccent
 uuid-ossp
 vector
 xml2

You can check the list of available extension:

SELECT * FROM pg_available_extensions;

and enabled one if needed

CREATE EXTENSION <NAME>;

If you noticed an extension that is widely used and of importance please highlight it in the comments and we will evaluate wheather to support it or not.
And for the moment, we don't plan to support all plugins.
I think you can customize the PG image to you need and replace the image address of Postgresql ClusterVersion /Componnet Version to your customized one.

You may refer to following repo to check out how we build the image and please feel free to contribute.

• https://github.com/apecloud-inc/spilo

[ruijun2002]

Here is the unique plugins that are supported by AWS RDS PostgreSQL and not supported by KubeBlocks, along with a brief description of what each plugin does.

Plugin Name	Version (if provided)	Description of Plugin Use
auto_explain	Built-in	Provides detailed information on query execution plans to aid in performance tuning.
bool_plperl	1.0	Allows the use of boolean type parameters and return values in PL/Perl functions.
flow_control	1.0	A control flow plugin often used for internal management or specific business logic controls.
h3-pg	1.34	H3 is Uber's open-source spatial indexing system; this plugin provides integration with PostgreSQL.
ICU module	60.2	Integrates the ICU library, providing comprehensive internationalization support including sorting and formatting.
ip4r	2.4	Offers support for IPv4 and IPv4 ranges, suitable for network-related applications.
jsonb_plperl	1.0	Allows handling of JSONB data types within the PL/Perl language environment.
log_fdw	1.0	A foreign data wrapper that allows PostgreSQL to access external log files as tables.
mysql_fdw	2.9	MySQL foreign data wrapper enabling PostgreSQL to read data from MySQL databases.
oracle_fdw	2.7.0	Oracle foreign data wrapper allowing PostgreSQL to access data stored in Oracle databases.
orafce	4.1	Provides Oracle-compatible features such as functions and packages to ease migration from Oracle.
pg_bigm	1.2	Provides BigM search methods suitable for full-text search, especially for Japanese content.
pg_hint_plan	1.4	Allows users to give hints directly to the query optimizer through SQL comments.
pg_proctab	0.1	Provides access to the operating system's process table which can be used for monitoring purposes.
pgactive	2.1	An active session monitoring tool that helps understand the current state of database connections.
plcoffee	3.1.10	Extends PostgreSQL to allow writing stored procedures in CoffeeScript.
plls	3.1.10	Extends PostgreSQL to allow writing stored procedures in LiveScript.
plperl	1.0	Extends PostgreSQL to write stored procedures using the Perl language.
plv8	1.0	Extends PostgreSQL to execute JavaScript code using the V8 JavaScript engine.
rds_tools	1.9	Contains a suite of utilities for managing and maintaining RDS PostgreSQL instances.
refint (contrib-spi)	1.0	Implements referential integrity checks ensuring foreign key constraints are properly enforced.
wal2json	2.6	Converts Write-Ahead Logging (WAL) into JSON format for easier parsing and analysis.

[shanshanying]

Converted the issue to Discussion.
As the list of PG plugins is quite long, KubeBlocks does not plan to support all of them.

Please feel to free to name the plugins you need in this discussion.