PostgreSQL 18 Extension Bugs

Please note that this list is not complete yet. Testing is still underway

Known PostgreSQL 18 problems in extension modules

Extensions that fail to build

• citus:https://github.com/citusdata/citus/issues/8028
• firebird_fdw: https://github.com/ibarwick/firebird_fdw/issues/47
• hdfs_fdw: https://github.com/EnterpriseDB/hdfs_fdw/issues/78
• hll: https://github.com/citusdata/postgresql-hll/issues/166
• jdbc_fdw: https://github.com/pgspider/jdbc_fdw/issues/52
• logerrors: https://github.com/munakoiso/logerrors/issues/29
• mongo_fdw: https://github.com/EnterpriseDB/mongo_fdw/issues/190
• multicorn2: https://github.com/pgsql-io/multicorn2/issues/76
• mysql_fdw: https://github.com/EnterpriseDB/mysql_fdw/issues/319
• odbc_fdw: https://github.com/CartoDB/odbc_fdw/issues/144
• pgaudit: https://github.com/pgaudit/pgaudit/issues/278
• pg_background: https://github.com/vibhorkum/pg_background/issues/68
• pg_bigm: https://github.com/pgbigm/pg_bigm/issues/28
• pg_bulkload: https://github.com/ossc-db/pg_bulkload/issues/172
• pg_checksums: https://github.com/credativ/pg_checksums/issues/14
• pgcopydb: https://github.com/dimitri/pgcopydb/issues/916
• pg_cron: https://github.com/citusdata/pg_cron/issues/396
• pg_hint_plans: https://github.com/ossc-db/pg_hint_plan/issues/224
• pg_failover_slots: https://github.com/EnterpriseDB/pg_failover_slots/issues/57
• pg_fincore: https://github.com/klando/pgfincore/issues/10
• pg_ivm: https://github.com/sraoss/pg_ivm/issues/133
• pgl_ddl_deploy: https://github.com/enova/pgl_ddl_deploy/issues/78
• pglogical: https://github.com/2ndQuadrant/pglogical/issues/499
• pg_net: https://github.com/supabase/pg_net/issues/204
• pg_qualstats: https://github.com/powa-team/pg_qualstats/issues/72
• pg_readonly: https://github.com/pierreforstmann/pg_readonly/issues/9

Extensions that build but regression tests fail

• ddlx: https://github.com/lacanoid/pgddl/issues/34
• pg_auth_mon: https://github.com/RafiaSabih/pg_auth_mon/issues/23
• pg_dbms_lock: This fails because of missing pg_background extension. Will try once pg_background is fixed.
• pg_roaringbitmap: https://github.com/ChenHuajun/pg_roaringbitmap/issues/39 (SERVER CRASH!)
• pg_profile: https://github.com/zubkov-andrei/pg_profile/issues/134
• pgq: https://github.com/pgq/pgq/issues/25 (not critical)

Discontinued extensions

• login_hook: https://github.com/splendiddata/login_hook/?tab=readme-ov-file#postgres-versions (feature is already included in v17)
• pg_auto_failover: https://github.com/hapostgres/pg_auto_failover (maintainer is away)
• pgcryptokey: https://momjian.us/download/pgcryptokey/
• periods: https://github.com/xocolatl/periods/ : Temporal primary keys are in v18.

Testing pending

• pgfaceting: Requires pg_roaringbitmap and see above.
• pg_incremental: Builds fine. Regression tests pending. Requires pg_roaringbitmap and see above.

Already working or fixed

• bgw_replstatus
• credcheck
• dbt2
• emaj
• extra_window_functions
• h3-pg (as of 4.2.3): https://github.com/zachasme/h3-pg/issues/179
• hypopg (as of 1.4.2): https://github.com/HypoPG/hypopg/issues/98
• icu_ext (as of 1.10.0): https://github.com/dverite/icu_ext/issues/20
• ip4r
• jsquery
• ogr_fdw
• orafce
• passwordcheck_cracklib
• pgagent
• pgbouncer_fdw
• pg_catcheck
• pg_curl
• pg_dbms_job
• pg_dbms_lock
• pg_dbms_metadata
• pg_dirtyread
• pgexportdoc
• pgexporter_ext
• pg_extra_time (#regress)
• pg_fact_loader
• pg_filedump
• pg_fkpart
• pgimportdoc
• pg_jobmon
• pgmemcache
• pgmeminfo
• pgmp
• pg_partman
• pgpcre
• pgpdf
• plpgsql_check : 2.8.1
• pg_permissions
• pg_prioritize
• pg_show_plans
• pg_store_plans : 2.3.1