Update pgrx, add postgres 16

maparent · maparent · commit fa34175e3ec7 · 2023-10-19T13:51:35.000-04:00
diff --git a/.github/workflows/ci.yml b/.github/workflows/ci.yml
@@ -52,7 +52,7 @@ jobs:
         run: |
           curl https://sh.rustup.rs -sSf | sh -s -- -y
           source ~/.cargo/env
-          cargo install cargo-pgrx --version "0.10.0" --locked
+          cargo install cargo-pgrx --version "0.10.1" --locked
 
           if [[ ! -d ~/.pgrx ]]; then
             cargo pgrx init
diff --git a/.github/workflows/ubuntu-packages-and-docker-image.yml b/.github/workflows/ubuntu-packages-and-docker-image.yml
@@ -72,11 +72,13 @@ jobs:
           libpq-dev \
           libclang-dev \
           wget \
+          postgresql-16 \
           postgresql-15 \
           postgresql-14 \
           postgresql-13 \
           postgresql-12 \
           postgresql-11 \
+          postgresql-server-dev-16 \
           postgresql-server-dev-15 \
           postgresql-server-dev-14 \
           postgresql-server-dev-13 \
@@ -98,13 +100,13 @@ jobs:
       with:
         working-directory: pgml-extension
         command: install
-        args: cargo-pgrx --version "0.10.0" --locked
+        args: cargo-pgrx --version "0.10.1" --locked
     - name: pgrx init
       uses: postgresml/gh-actions-cargo@master
       with:
         working-directory: pgml-extension
         command: pgrx
-        args: init --pg11=/usr/lib/postgresql/11/bin/pg_config --pg12=/usr/lib/postgresql/12/bin/pg_config --pg13=/usr/lib/postgresql/13/bin/pg_config --pg14=/usr/lib/postgresql/14/bin/pg_config --pg15=/usr/lib/postgresql/15/bin/pg_config
+        args: init --pg11=/usr/lib/postgresql/11/bin/pg_config --pg12=/usr/lib/postgresql/12/bin/pg_config --pg13=/usr/lib/postgresql/13/bin/pg_config --pg14=/usr/lib/postgresql/14/bin/pg_config --pg15=/usr/lib/postgresql/15/bin/pg_config --pg16=/usr/lib/postgresql/16/bin/pg_config
     - name: Build Postgres 11
       uses: postgresml/gh-actions-cargo@master
       with:
@@ -135,6 +137,12 @@ jobs:
         working-directory: pgml-extension
         command: pgrx
         args: package --pg-config /usr/lib/postgresql/15/bin/pg_config
+    - name: Build Postgres 16
+      uses: postgresml/gh-actions-cargo@master
+      with:
+        working-directory: pgml-extension
+        command: pgrx
+        args: package --pg-config /usr/lib/postgresql/16/bin/pg_config
     - name: Build debs
       env:
         AWS_ACCESS_KEY_ID: ${{ vars.AWS_ACCESS_KEY_ID }}
diff --git a/pgml-docs/docs/guides/deploying-postgresml/self-hosting/README.md b/pgml-docs/docs/guides/deploying-postgresml/self-hosting/README.md
@@ -31,7 +31,7 @@ Finally, you can install PostgresML:
 sudo apt install -y postgresml-14
 ```
 
-Ubuntu 22.04 ships with PostgreSQL 14, but if you have a different version installed on your system, just change `14` in the package name to your Postgres version. We currently support all  versions supported by the community: Postgres 12 through 15.
+Ubuntu 22.04 ships with PostgreSQL 14, but if you have a different version installed on your system, just change `14` in the package name to your Postgres version. We currently support all  versions supported by the community: Postgres 12 through 16.
 
 ### Validate your installation
 
diff --git a/pgml-docs/docs/guides/deploying-postgresml/self-hosting/building-from-source.md b/pgml-docs/docs/guides/deploying-postgresml/self-hosting/building-from-source.md
@@ -40,12 +40,12 @@ For a typical deployment in production, you would need to compile and install th
 
 #### Install pgrx
 
-`pgrx` is open source and available from crates.io. We are currently using the `0.10.0` version. It's important that your `pgrx` version matches what we're using, since there are some hard dependencies between our code and `pgrx`.
+`pgrx` is open source and available from crates.io. We are currently using the `0.10.1` version. It's important that your `pgrx` version matches what we're using, since there are some hard dependencies between our code and `pgrx`.
 
 To install `pgrx`, simply run:
 
 ```
-cargo install cargo-pgrx --version "0.10.0"
+cargo install cargo-pgrx --version "0.10.1"
 ```
 
 Before using `pgrx`, it needs to be initialized against the installed version of PostgreSQL. In this example, we'll be using the Ubuntu 22.04 default PostgreSQL 14 installation:
diff --git a/pgml-extension/Cargo.lock b/pgml-extension/Cargo.lock
diff --git a/pgml-extension/Cargo.toml b/pgml-extension/Cargo.toml
@@ -13,14 +13,15 @@ pg12 = ["pgrx/pg12", "pgrx-tests/pg12"]
 pg13 = ["pgrx/pg13", "pgrx-tests/pg13"]
 pg14 = ["pgrx/pg14", "pgrx-tests/pg14"]
 pg15 = ["pgrx/pg15", "pgrx-tests/pg15"]
+pg16 = ["pgrx/pg16", "pgrx-tests/pg16"]
 use_as_lib = []
 pg_test = []
 python = ["pyo3"]
 cuda = ["xgboost/cuda", "lightgbm/cuda"]
 
 [dependencies]
-pgrx = "=0.10.0"
-pgrx-pg-sys = "=0.10.0"
+pgrx = "=0.10.1"
+pgrx-pg-sys = "=0.10.1"
 xgboost = { git = "https://github.com/postgresml/rust-xgboost.git", branch = "master" }
 once_cell = { version = "1", features = ["parking_lot"] }
 rand = "0.8"
@@ -51,7 +52,7 @@ flate2 = "1.0"
 csv = "1.2"
 
 [dev-dependencies]
-pgrx-tests = "=0.10.0"
+pgrx-tests = "=0.10.1"
 
 [build-dependencies]
 vergen = { version = "8", features = ["build", "git", "gitcl"] }
