Title: DR-000038 - PostgreSQL Upgrade to 16  
Owner: Julian Ladisch
Creator: Julian Ladisch Sep 28, 2023
Last Changed by: Jenn Colt May 06, 2024
Tiny Link: (useful for email) https://folio-org.atlassian.net/wiki/x/rCtN
Export As: Word · PDF  
Technical Council (13)
    Page: 2023-11-08 - Officially Supported Technologies
    Page: 2023-11-13 Meeting notes
    Page: 2023-11-20 Meeting notes
    Page: 2023-11-27 Meeting notes
    Page: 2023-12-04 Meeting notes
    Page: 2023-12-11 Meeting notes
    Page: 2024-01-22 Meeting notes
    Page: 2024-01-29 Meeting notes
    Page: 2024-02-05 Meeting notes
    Page: 2024-02-12 Meeting notes
    Page: 2024-02-19 Meeting notes
    Page: 2024-02-26 Meeting notes
    Page: Quesnelia
Labels
Global Labels (3)
Time Editor  
May 06, 2024 13:15 Jenn Colt View Changes
Dec 13, 2023 15:22 Craig McNally View Changes
Nov 30, 2023 12:57 Julian Ladisch View Changes
Nov 30, 2023 11:02 Julian Ladisch View Changes
Nov 30, 2023 11:01 Julian Ladisch  
Outgoing Links
External Links (210)
    https://www.postgresql.org/docs/14/seg.html
    https://www.postgresql.org/docs/13/functions-matching.html#…
    https://www.postgresql.org/docs/16/sql-createindex.html
    https://github.com/search?q=org%3Afolio-org+vacuum_defer_cl…
    https://www.postgresql.org/docs/15/app-pgdump.html
    https://github.com/search?q=org%3Afolio-org+pg_stat_ssl&typ…
    https://www.postgresql.org/docs/14/protocol.html
    https://www.postgresql.org/docs/13/monitoring-stats.html#PG…
    https://github.com/search?q=org%3Afolio-org+%22ALTER+FOREIG…
    https://www.postgresql.org/docs/15/libpq-async.html#LIBPQ-P…
    https://github.com/search?q=org%3Afolio-org+%22ON+SELECT%22…
    https://github.com/search?q=org%3Afolio-org+single-transact…
    https://github.com/julianladisch/mod-orders-storage/actions…
    https://github.com/search?q=org%3Afolio-org%20hash_mem_mult…
    https://www.postgresql.org/docs/14/runtime-config-connectio…
    https://github.com/search?q=org%3Afolio-org+%22escape+null%…
    https://github.com/search?q=org%3Afolio-org+stddev_samp&typ…
    https://www.postgresql.org/docs/14/release-14.html#id-1.11.…
    https://www.postgresql.org/docs/16/pgupgrade.html
    https://github.com/julianladisch/mod-oai-pmh/actions/runs/6…
    https://github.com/search?q=org%3Afolio-org+xml_is_well_for…
    https://github.com/julianladisch/mod-bulk-operations/action…
    https://www.postgresql.org/docs/14/xfunc-sql.html#XFUNC-SQL…
    https://github.com/julianladisch/mod-login/actions/runs/700…
    https://github.com/search?q=org%3Afolio-org%20intarray&type…
    https://www.postgresql.org/docs/16/app-pg-ctl.html
    https://github.com/search?q=org%3Afolio-org%20pg_standby&ty…
    https://www.postgresql.org/docs/16/sql-createrole.html
    https://github.com/search?q=org%3Afolio-org+to_tsquery&type…
    https://github.com/julianladisch/mod-dcb/actions/runs/69905…
    https://github.com/search?q=org%3Afolio-org+lc_collate&type…
    https://www.postgresql.org/docs/14/functions-matching.html#…
    https://github.com/search?q=org%3Afolio-org+%22CREATE+LANGU…
    https://github.com/search?q=org%3Afolio-org+%22open+%22+cur…
    https://www.postgresql.org/docs/13/release-13.html#id-1.11.…
    https://github.com/search?q=org%3Afolio-org+explain&type=co…
    https://www.postgresql.org/docs/13/monitoring-stats.html#WA…
    https://github.com/julianladisch/mod-source-record-storage/…
    https://www.postgresql.org/docs/15/datatype-datetime.html
    https://github.com/julianladisch/mod-finc-config/actions/ru…
    https://github.com/julianladisch/mod-data-export-spring/act…
    https://github.com/search?q=org%3Afolio-org+%22chr%28%22&ty…
    https://aws.amazon.com/rds/postgresql/
    https://www.postgresql.org/docs/15/monitoring-stats.html#MO…
    https://www.postgresql.org/docs/14/functions-matching.html#…
    https://github.com/search?q=org%3Afolio-org+stats_temp_dire…
    https://www.postgresql.org/docs/13/runtime-config-replicati…
    https://www.postgresql.org/docs/13/runtime-config-resource.…
    https://github.com/search?q=org%3Afolio-org+%22CREATE+OPERA…
    https://github.com/search?q=org%3Afolio-org+pg_get_wal_reco…
    https://github.com/search?q=org%3Afolio-org+json_to_tsvecto…
    https://www.postgresql.org/docs/14/functions-datetime.html
    https://github.com/search?q=org%3Afolio-org+%22NULLS+NOT+DI…
    https://github.com/search?q=org%3Afolio-org+postgres_fdw&ty…
    https://github.com/search?q=org%3Afolio-org+%22REINDEX+DATA…
    https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCH…
    https://github.com/search?q=org%3Afolio-org+bt_metap&type=c…
    https://www.postgresql.org/docs/16/warm-standby.html#STREAM…
    https://www.postgresql.org/docs/15/postgres-fdw.html
    https://github.com/search?q=org%3Afolio-org+pg_stat_gssapi&…
    https://github.com/search?q=org%3Afolio-org+width_bucket&ty…
    https://www.postgresql.org/docs/15/sql-syntax-lexical.html#…
    https://www.postgresql.org/docs/13/sql-createopclass.html
    https://github.com/search?q=org%3Afolio-org+array_replace&t…
    https://www.postgresql.org/docs/16/runtime-config-replicati…
    https://github.com/julianladisch/mod-tags/actions/runs/6946…
    https://www.postgresql.org/docs/14/runtime-config-connectio…
    https://www.postgresql.org/docs/15/sql-createview.html
    https://github.com/search?q=org%3Afolio-org+array_positions…
    https://github.com/julianladisch/mod-finance-storage/action…
    https://www.postgresql.org/docs/14/intarray.html
    https://docs.folio.org/docs/getting-started/installation/#p…
    https://github.com/search?q=org%3Afolio-org%20pg_statio_all…
    https://www.postgresql.org/docs/16/app-reindexdb.html
    https://github.com/julianladisch/mod-data-export-worker/act…
    https://www.postgresql.org/docs/15/plpython.html
    https://github.com/julianladisch/mod-calendar/actions/runs/…
    https://www.postgresql.org/docs/15/runtime-config-custom.ht…
    https://github.com/search?q=org%3Afolio-org+ltree&type=code
    https://www.postgresql.org/docs/16/sql-grant.html
    https://github.com/julianladisch/mod-inn-reach/actions/runs…
    https://github.com/search?q=org%3Afolio-org+cube&type=code
    https://www.postgresql.org/docs/14/runtime-config-custom.ht…
    https://www.postgresql.org/docs/16/pgwalinspect.html
    https://www.postgresql.org/docs/16/sql-createview.html
    https://www.postgresql.org/docs/15/release-15.html#id-1.11.…
    https://github.com/search?q=org%3Afolio-org+CREATEROLE&type…
    https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCH…
    https://github.com/julianladisch/mod-quick-marc/actions/run…
    https://www.postgresql.org/docs/14/functions-info.html
    https://www.postgresql.org/docs/14/sql-expressions.html#SYN…
    https://github.com/search?q=org%3Afolio-org+pg_get_wal_stat…
    https://github.com/julianladisch/mod-feesfines/actions/runs…
    https://github.com/julianladisch/mod-data-export/actions/ru…
    https://github.com/search?q=org%3Afolio-org+normal_rand&typ…
    https://sonarcloud.io/organizations/folio-org/projects?sort…
    https://www.postgresql.org/docs/13/sql-alterforeigntable.ht…
    https://github.com/search?q=org%3Afolio-org+array_prepend&t…
    https://github.com/search?q=org%3Afolio-org%20pg_is_in_back…
    https://github.com/search?q=org%3Afolio-org+%22U%26%22&type…
    https://github.com/julianladisch/mod-audit/actions/runs/694…
    https://github.com/search?q=org%3Afolio-org+%22create+exten…
    https://github.com/search?q=org%3Afolio-org+justify_day&typ…
    https://github.com/julianladisch/mod-patron-blocks/actions/…
    https://github.com/folio-org/mod-finance-storage/pull/370/f…
    https://github.com/search?q=org%3Afolio-org%20array_to_tsve…
    https://github.com/julianladisch/mod-inventory-storage/acti…
    https://www.postgresql.org/docs/13/monitoring-stats.html#PG…
    https://github.com/search?q=org%3Afolio-org+%22inf+precedin…
    https://github.com/search?q=org%3Afolio-org+%22CREATE+OPERA…
    https://github.com/julianladisch/mod-data-import/actions/ru…
    https://www.postgresql.org/docs/15/app-psql.html
    https://github.com/search?q=org%3Afolio-org+has_column_priv…
    https://www.postgresql.org/docs/15/datatype-json.html
    https://github.com/search?q=org%3Afolio-org+%22factorial%22…
    https://github.com/search?q=org%3Afolio-org%20IntervalStyle…
    https://github.com/search?q=org%3Afolio-org+lc_ctype&type=c…
    https://www.postgresql.org/docs/15/runtime-config-resource.…
    https://github.com/search?q=org%3Afolio-org+PQsendQuery&typ…
    https://www.postgresql.org/docs/15/xml2.html
    https://github.com/search?q=org%3Afolio-org%20plpythonu&typ…
    https://www.postgresql.org/docs/14/libpq.html
    https://www.postgresql.org/docs/14/sql-createlanguage.html
    https://github.com/search?q=org%3Afolio-org+array_cat&type=…
    https://www.postgresql.org/docs/13/sql-createextension.html
    https://www.postgresql.org/docs/14/functions-array.html
    https://github.com/julianladisch/mod-circulation-storage/ac…
    https://github.com/search?q=org%3Afolio-org+no-synchronized…
    https://www.postgresql.org/docs/15/sql-explain.html
    https://www.postgresql.org/docs/13/datetime-posix-timezone-…
    https://www.postgresql.org/docs/15/functions-string.html#FU…
    https://www.postgresql.org/docs/16/functions-admin.html#FUN…
    https://www.postgresql.org/docs/14/hstore.html
    https://aws.amazon.com/about-aws/whats-new/2023/02/amazon-r…
    https://github.com/julianladisch/mod-invoice/actions/runs/6…
    https://www.postgresql.org/support/versioning/
    https://github.com/search?q=org%3Afolio-org+intarray&type=c…
    https://www.postgresql.org/docs/15/sql-createrole.html
    https://github.com/search?q=org%3Afolio-org+justify_interva…
    https://github.com/julianladisch/mod-pubsub/actions/runs/70…
    https://github.com/search?q=org%3Afolio-org+array_remove&ty…
    https://github.com/julianladisch/mod-remote-storage/actions…
    https://github.com/search?q=org%3Afolio-org+force_parallel_…
    https://github.com/julianladisch/mod-consortia/actions/runs…
    https://github.com/search?q=org%3Afolio-org%20pg_start_back…
    https://github.com/search?q=org%3Afolio-org%20pg_stop_backu…
    https://github.com/search?q=org%3Afolio-org+%22MATCH+FULL%2…
    https://www.postgresql.org/docs/13/functions-textsearch.htm…
    https://github.com/search?q=org%3Afolio-org+%22DROP+LANGUAG…
    https://github.com/search?q=org%3Afolio-org+websearch_to_ts…
    https://folio-org.atlassian.net/wiki/display/TC/2023-11-20+…
    https://github.com/search?q=org%3Afolio-org+%22CREATE+EXTEN…
    https://github.com/julianladisch/okapi/actions/runs/7006158…
    https://github.com/search?q=org%3Afolio-org+set_rel_pathlis…
    https://github.com/julianladisch/mod-eusage-reports/actions…
    https://folio-org.atlassian.net/wiki/display/TC/DR-000037+-…
    https://www.postgresql.org/docs/14/functions-aggregate.html
    https://www.postgresql.org/docs/13/pageinspect.html
    https://github.com/search?q=org%3Afolio-org+array_append&ty…
    https://www.postgresql.org/docs/14/functions-textsearch.htm…
    https://github.com/julianladisch/mod-reservoir/actions/runs…
    https://github.com/search?q=org%3Afolio-org+justify_hours&t…
    https://github.com/search?q=org%3Afolio-org+jsonb_to_tsvect…
    https://github.com/julianladisch/mod-erm-usage/actions/runs…
    https://www.postgresql.org/docs/15/functions-textsearch.htm…
    https://github.com/search?q=org%3Afolio-org+wait_event&type…
    https://www.postgresql.org/docs/16/sql-reindex.html
    https://www.postgresql.org/docs/14/functions-math.html
    https://www.postgresql.org/docs/16/ddl-generated-columns.ht…
    https://www.postgresql.org/docs/14/sql-createoperator.html
    https://www.postgresql.org/docs/15/functions-math.html#FUNC…
    https://github.com/julianladisch/mod-entities-links/actions…
    https://www.postgresql.org/docs/14/functions-geometry.html
    https://github.com/search?q=org%3Afolio-org+hstore&type=cod…
    https://github.com/search?q=org%3Afolio-org+random()&type=c…
    https://www.postgresql.org/docs/14/tablefunc.html
    https://www.postgresql.org/docs/15/logical-replication.html
    https://github.com/julianladisch/mod-users/actions/runs/694…
    https://www.postgresql.org/docs/16/plpgsql-cursors.html#PLP…
    https://github.com/search?q=org%3Afolio-org%20plpython2u&ty…
    https://www.postgresql.org/docs/13/sql-createtype.html
    https://github.com/search?q=org%3Afolio-org+%22inf+followin…
    https://github.com/julianladisch/mod-lists/actions/runs/699…
    https://www.postgresql.org/docs/15/functions-datetime.html#…
    https://github.com/julianladisch/mod-source-record-manager/…
    https://www.postgresql.org/docs/13/monitoring-stats.html#PG…
    https://github.com/julianladisch/mod-search/actions/runs/69…
    https://www.postgresql.org/docs/14/ecpg.html
    https://www.postgresql.org/docs/16/runtime-config-developer…
    https://www.postgresql.org/docs/13/ltree.html
    https://www.postgresql.org/docs/14/cube.html
    https://github.com/julianladisch/mod-erm-usage-harvester/ac…
    https://www.postgresql.org/docs/13/sql-altermaterializedvie…
    https://github.com/folio-org/raml-module-builder/commit/dfa…
    https://github.com/julianladisch/mod-di-converter-storage/a…
    https://www.postgresql.org/docs/15/runtime-config-resource.…
    https://www.postgresql.org/docs/16/plpgsql-cursors.html#PLP…
    https://github.com/search?q=org%3Afolio-org++INTERNALLENGTH…
    https://www.postgresql.org/docs/16/release-16.html#RELEASE-…
    https://github.com/search?q=org%3Afolio-org+var_samp&type=c…
    https://www.postgresql.org/docs/15/runtime-config-client.ht…
    https://github.com/search?q=org%3Afolio-org%20pg_backup_sta…
    https://www.postgresql.org/docs/13/sql-altertable.html
    https://github.com/search?q=org%3Afolio-org+%22ALTER+MATERI…
    https://www.postgresql.org/docs/15/custom-scan.html
    https://www.postgresql.org/docs/15/sql-syntax-lexical.html#…
    https://www.postgresql.org/docs/15/continuous-archiving.htm…
    https://github.com/search?q=org%3Afolio-org+array_position&…
    https://github.com/search?q=org%3Afolio-org+promote_trigger…
    https://www.postgresql.org/docs/14/auth-pg-hba-conf.html
Technical Council (1)     Page: DR-000037 - TESTCONTAINERS_POSTGRES_IMAGE