Sam/oriole17 (#1298)
* feat: build and flake check of pg 16.3 with exts/wrappers
* pg_partman test 15/16 compat
* merge sql interface test
* tests: build test and cache both versions
* chore: run checks individually
* pg 15 and 16 packer/ansible/ghactions (#1268)
* fix: reformat ec2 cleanup commands (#1267)
Co-authored-by: Sam Rose <samuel@supabase.io>
* feat: build and flake check of pg 16.3 with exts/wrappers
* pg_partman test 15/16 compat
* merge sql interface test
* tests: build test and cache both versions
* chore: run checks individually
* feat: realease 15 and 16 to staging
* chore: update versions
* chore: make yq available
* chore: run yq from nix
* chore: more setup for staging AMI
* fix: yq usage
* chore: shell vars
* fix: When --init none is used, only users who can elevate to sudo privileges can run Nix
* fix: no -i
* fix: quote correction
* fix: newline extra quotes
* fix: no need for pg major version on packer
* fix: postgresql_major
* fix: ql
* fix: no ansible args in stage to invocation
* fix: unique val
* fix: adjustments to build scripts
* chore: env var handling
* fix: bump to build
* chore: set up more required vars
* chore: bump var
* feat: pg 16 debug symbols
* feat: matrix pg versions build on testinfra
* feat: matrix on Test Database
* chore: running nix in the right context
* feat: just use existing Dockerfile + pg version
* chore: refer to var
* fix: read name without including quotes
* chore: try format function
* fix: strip quotes from version number
* chore: env var
* fix: pg client
* fix
* fix: try to use psql from our own corresponding pkg
* fix: try psql from ppa
* fix: dbmate per pg version
* build dbmate and then install client
* fix: account for architecture
* chore: limit changes detection migrations/schema.sql
* missing docker compose call
* ore: drop tests while investigating
* test: try on pg15 only
* chore: schema needs update
* chore: now run on all versions in matrix
* test: trying a version of schema per major pg version as there are type diffs
---------
Co-authored-by: Sam Rose <samuel@supabase.io>
Co-authored-by: Oliver Rice <github@oliverrice.com>
* chore: rm dead code
* chore: resolve versions from ansible/vars.yml instead of packer file
create a matrix build for 15 16 (or how ever many versions there are)
* feat: WIP orioledb 16
* feat: intro into CI building psql16 bundle oriole version
* test: working through build compat for oriole
* working orioledb build
* fix: update value
* chore: cut staging only release for oriole16
* narrow down to just oriole staging ami here
* fix: make sure name lines up with gh action convention
* fix: get correct naming convention in here too for oriole bundle
* chore: bump to cut release
* fix: make sure src and debug builds available for oriole too
* chore: bump to staging release
* fix: when oriole16 rm timescale from supautils conf
* fix: also remove from postgresql conf
* fix: find all instances and remove in this condition for tiemscaledb
* fix: maybe broke pgsodium with too many spaces
* fix: create a symlink for missing path
* fix: try a more universal way to deactivate pgsodium at this stage
* chore: when oriole16 rm timescale plv8 postgis pgvector pgrouting
* fix: more handling of oriole16 differences
* chore more oriole16 handling
* fix: refine sed regex
* fix: also cond rm actual files
* fix: correct dir
* chore: bump to release
* feat: parse and handle oropledb-16 in start-server
* feat: start-client for oriole16
* wip for orioledb push to build on linux
* fix: running server
* chore: consolidate nix code that handles building of postgres versions
* fix: update name for bundle
* chore: small cleanup
* chore: bump version release
* chore: cleanup names
* chore: correct names
* fix: var name
* fix: one more var name
* chore: bump to release
* fix: reformatting metadata for clikchouse dep as git was not able to fetch
* feat: wip refactor to pg 17 for orioledb
* feat: working orioledb-17
* fix: increase role duration to avoid expiration
* fix: correct version
* fix: clickhouse needs git in build inputs
* fix: install and then remove git for clickhouse dep
* fix: correct rules for version
* fix: db_user_namespace was deprecated starting in pg 16.4 and higher
* apply fix for wrappers build, deactivate ext in unit test
* chore: deactivate more tests due to deactivated extensions
* fix: also remove from sql file
* fix: regex
* fix: also remove ref here
* fix: graphql_public schema too
* chore: correct dir
* chore: staging release
* feat: re-introduce wal2json rum and pgvector
* fix: also restore pgvector in start-server
* chore: bump staging release
* feat: oriole specific default settings
* feat: use icu for locales only if building orioledb
* fix: need var in stage 1 too
* fix: settings must be in db init
* fix: ansible args
* fix: PostgreSQL uses ICU for all locale-related operations, so we don't need to specify the collation and character type settings separately.
* chore: add a migration for orioledb activation by default
* feat: turn on oriole if oriole ext exists
* test: conditional on test for orioledb
* fix: salt changed repo and method for adding apt package
* fix: udpate salt minion setup
* fix: silent skip if oriole not in the install
* test: check if oriole is available and if so then enable
* chore: build and cache src and debug pkgs as well
* fix: tmp supress build of src and debug
* chore: tmp disable src and debug
* fix: activate oriole first in the oriole context
* fix: pgroonga build on macos
* fix: restore flake check for now
* fixing flake check for darwin + passing check until pg_net
* fix: start-server macos
* fix: src yq from apt
* fix: all instances yq
* fix: jq invoke
* fix: nix profile install
* fix: nix run
* fix: sudo nix run
* chore: cut staging release
* chore: rm debugging
* fix: still need CURRENT_SYSTEM
* test: re-introduce flake checks for 15 and 16
* chore: bump versions of patched pg for oriole to 17_4 and ext to beta6
* chore: bump var to release ami
* chore: break down into functions
* fix: skip x86 darwin for oriole nix builds
* chore: cleanup repo for final review, rebase and merge
* fix: try to properly init db in non oriole context
* chore: restore installation of debug and src for all versions`
* chore: newline
* chore: cleaning up and restoring missing code
* chore: cleanup
* chore: fix gh action conditonal for oriole
* fix: filter orioledb-17 from test on read
---------
Co-authored-by: Oliver Rice <github@oliverrice.com>
