Skip to content

Releases: supabase/postgres

15.6.1.143-vault-1

28 Nov 08:17
Compare
Choose a tag to compare

15.6.1.139-qemu.1

27 Nov 03:18
Compare
Choose a tag to compare
chore: upgrade to latest adminapi release

16.3.1.019

26 Nov 04:22
1013796
Compare
Choose a tag to compare
chore: bump releases (#1339)

* chore: bump releases

* chore: somehow -- migrate:up was missing

* fix: update to use current version in dbmate test

* chore: missing env.

* chore: cleanup

15.8.1.013

27 Nov 17:18
1013796
Compare
Choose a tag to compare
chore: bump releases (#1339)

* chore: bump releases

* chore: somehow -- migrate:up was missing

* fix: update to use current version in dbmate test

* chore: missing env.

* chore: cleanup

orioledb-17.0.1.001

26 Nov 03:58
1013796
Compare
Choose a tag to compare
chore: bump releases (#1339)

* chore: bump releases

* chore: somehow -- migrate:up was missing

* fix: update to use current version in dbmate test

* chore: missing env.

* chore: cleanup

16.3.1.011

25 Nov 23:08
897d9f3
Compare
Choose a tag to compare
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 <[email protected]>

* 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 <[email protected]>
Co-authored-by: Oliver Rice <[email protected]>

* 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 <[email protected]>

15.8.1.005

25 Nov 23:11
897d9f3
Compare
Choose a tag to compare
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 <[email protected]>

* 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 <[email protected]>
Co-authored-by: Oliver Rice <[email protected]>

* 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 <[email protected]>

15.6.1.143

25 Nov 16:50
63303c6
Compare
Choose a tag to compare
pgmq in 15.6 image (#1337)

* pick pgmq to 15.6

* update extension interface test output

* bump image version

orioledb-17.0.1.000

25 Nov 23:04
897d9f3
Compare
Choose a tag to compare
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 <[email protected]>

* 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 <[email protected]>
Co-authored-by: Oliver Rice <[email protected]>

* 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 <[email protected]>

15.6.1.142

21 Nov 14:32
Compare
Choose a tag to compare
feat: supautils v2.5.0