Open5

AWS RDS PostgreSQLのrds.allowed_extensions

nhnh

Major Version Up時、全てを許可するかどうかは別として、全てを許可する設定のリストを記録。ここから削れば、エラーにはなりにくい。

各バージョンで、次を実行した結果
SELECT distinct(name) as name FROM pg_available_extension_versions;

nhnh

PostgreSQL 14

address_standardizer, address_standardizer_data_us, amcheck, autoinc, aws_commons, aws_lambda, aws_s3, bloom, bool_plperl, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, flow_control, fuzzystrmatch, h3, h3_postgis, hll, hstore, hstore_plperl, hypopg, insert_username, intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, ltree, moddatetime, mysql_fdw, oracle_fdw, orafce, pageinspect, pgactive, pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattuple, pgtap, pg_bigm, pg_buffercache, pg_cron, pg_freespacemap, pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_similarity, pg_stat_statements, pg_tle, pg_transport, pg_trgm, pg_visibility, plcoffee, plls, plperl, plpgsql, plprofiler, plrust, pltcl, plv8, postgis, postgis_raster, postgis_tiger_geocoder, postgis_topology, postgres_fdw, prefix, rdkit, rds_tools, refint, seg, sslinfo, tablefunc, tcn, tds_fdw, test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp, vector

nhnh

PostgreSQL 15

address_standardizer,address_standardizer_data_us,amcheck,autoinc,aws_commons,aws_lambda,aws_s3,bloom,bool_plperl,btree_gin,btree_gist,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,flow_control,fuzzystrmatch,h3,h3_postgis,hll,hstore,hstore_plperl,hypopg,insert_username,intagg,intarray,ip4r,isn,jsonb_plperl,lo,log_fdw,ltree,moddatetime,mysql_fdw,old_snapshot,oracle_fdw,orafce,pageinspect,pg_bigm,pg_buffercache,pg_cron,pg_freespacemap,pg_hint_plan,pg_partman,pg_prewarm,pg_proctab,pg_repack,pg_similarity,pg_stat_statements,pg_tle,pg_transport,pg_trgm,pg_visibility,pg_walinspect,pgactive,pgaudit,pgcrypto,pglogical,pgrouting,pgrowlocks,pgstattuple,pgtap,plcoffee,plls,plperl,plpgsql,plprofiler,plrust,pltcl,plv8,postgis,postgis_raster,postgis_tiger_geocoder,postgis_topology,postgres_fdw,prefix,rdkit,rds_tools,refint,seg,sslinfo,tablefunc,tcn,tds_fdw,test_parser,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp,vector

nhnh

PostgreSQL 16
※15と同じ

address_standardizer,address_standardizer_data_us,amcheck,autoinc,aws_commons,aws_lambda,aws_s3,bloom,bool_plperl,btree_gin,btree_gist,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,flow_control,fuzzystrmatch,h3,h3_postgis,hll,hstore,hstore_plperl,hypopg,insert_username,intagg,intarray,ip4r,isn,jsonb_plperl,lo,log_fdw,ltree,moddatetime,mysql_fdw,old_snapshot,oracle_fdw,orafce,pageinspect,pg_bigm,pg_buffercache,pg_cron,pg_freespacemap,pg_hint_plan,pg_partman,pg_prewarm,pg_proctab,pg_repack,pg_similarity,pg_stat_statements,pg_tle,pg_transport,pg_trgm,pg_visibility,pg_walinspect,pgactive,pgaudit,pgcrypto,pglogical,pgrouting,pgrowlocks,pgstattuple,pgtap,plcoffee,plls,plperl,plpgsql,plprofiler,plrust,pltcl,plv8,postgis,postgis_raster,postgis_tiger_geocoder,postgis_topology,postgres_fdw,prefix,rdkit,rds_tools,refint,seg,sslinfo,tablefunc,tcn,tds_fdw,test_parser,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp,vector

nhnh

PostgreSQL 17

address_standardizer,address_standardizer_data_us,amcheck,autoinc,aws_commons,aws_lambda,aws_s3,bloom,bool_plperl,btree_gin,btree_gist,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,flow_control,fuzzystrmatch,h3,h3_postgis,hll,hstore,hstore_plperl,hypopg,insert_username,intagg,intarray,ip4r,isn,jsonb_plperl,lo,log_fdw,ltree,moddatetime,mysql_fdw,oracle_fdw,orafce,pageinspect,pg_bigm,pg_buffercache,pg_cron,pg_freespacemap,pg_hint_plan,pg_partman,pg_prewarm,pg_proctab,pg_repack,pg_similarity,pg_stat_statements,pg_tle,pg_transport,pg_trgm,pg_visibility,pg_walinspect,pgactive,pgaudit,pgcrypto,pglogical,pgrouting,pgrowlocks,pgstattuple,pgtap,plcoffee,plls,plperl,plpgsql,plprofiler,plrust,pltcl,plv8,postgis,postgis_raster,postgis_tiger_geocoder,postgis_topology,postgres_fdw,prefix,rdkit,rds_tools,refint,seg,sslinfo,tablefunc,tcn,tds_fdw,test_parser,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp,vector