PostgreSQL 18 Extension Bugs

Please note that this list is not complete yet. Testing is still underway. Please DO NOT EDIT THIS PAGE unless you are Devrim or Christoph.

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.
• pg_similarity

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_readme (#regress)
• pg_repack
• pg_show_plans
• pg_store_plans : 2.3.1
• pgrouting
• PostGIS 3.5
• PostGIS 3.6
• repmgr