diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2021-04-07 18:44:14 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2022-01-26 18:02:31 -0800 |
| commit | 909eb1e37214fe0d5f0efb54bb37700cf10c7013 (patch) | |
| tree | a0090ca6301f0785b7f63371acb1a2ccb723c525 | |
| parent | 106d7bb86295f5ca1599c2ef85f2ed8a6c4fa69e (diff) | |
| download | fatcat-909eb1e37214fe0d5f0efb54bb37700cf10c7013.tar.gz fatcat-909eb1e37214fe0d5f0efb54bb37700cf10c7013.zip | |
upgrade gitlab CI, docs, and various scripts from postgresql 11 to 13
Expecting few if any compatibility issues with this transition.
Actually upgrading the production databases will be some work, but will
hopefully yield disk savings from changes in the B-Tree index on-disk
format.
| -rw-r--r-- | .gitlab-ci.yml | 2 | ||||
| -rw-r--r-- | rust/INSTALL.md | 2 | ||||
| -rw-r--r-- | rust/migrations/2019-01-01-000000_init/up.sql | 1 | ||||
| -rwxr-xr-x | rust/tests/pg_tmp.sh | 2 |
4 files changed, 4 insertions, 3 deletions
diff --git a/.gitlab-ci.yml b/.gitlab-ci.yml index f71e2d77..9746b8ce 100644 --- a/.gitlab-ci.yml +++ b/.gitlab-ci.yml @@ -24,7 +24,7 @@ unified_test: DATABASE_URL: "postgres://fatcat_user:fatcat_pw@postgres/fatcat_test" TEST_DATABASE_URL: "postgres://fatcat_user:fatcat_pw@postgres/fatcat_test" services: - - "postgres:11" + - "postgres:13" before_script: - export PATH="$PATH:$CARGO_HOME/bin" - apt update -qy diff --git a/rust/INSTALL.md b/rust/INSTALL.md index 462072dc..3f8b6b84 100644 --- a/rust/INSTALL.md +++ b/rust/INSTALL.md @@ -7,7 +7,7 @@ directions are likely to end up out-of-date. To install manually, on a bare server, as root: adduser fatcat - apt install postgresql-11 postgresql-contrib postgresql-client-11 \ + apt install postgresql-13 postgresql-contrib postgresql-client-13 \ nginx build-essential git pkg-config libssl-dev libpq-dev \ htop screen mkdir -p /srv/fatcat diff --git a/rust/migrations/2019-01-01-000000_init/up.sql b/rust/migrations/2019-01-01-000000_init/up.sql index 5211b29a..519e5961 100644 --- a/rust/migrations/2019-01-01-000000_init/up.sql +++ b/rust/migrations/2019-01-01-000000_init/up.sql @@ -1,5 +1,6 @@ -- written for Postgres 9.6 with OSSP extension for UUIDs -- ... but actually runs on Postgres 11 in qa/production/tests +-- ... and now Postgres 13 -- Previously VARCHAR and fixed-size CHAR was used in this schema for specific -- columns (especially fixed-size external identifiers, and hashes). This was diff --git a/rust/tests/pg_tmp.sh b/rust/tests/pg_tmp.sh index 2036a76c..ae6860ef 100755 --- a/rust/tests/pg_tmp.sh +++ b/rust/tests/pg_tmp.sh @@ -41,7 +41,7 @@ done # bnewbold: hack this in to "make it work" on debian/ubuntu # bnewbold: also note, pg_virtualenv could also work, but is ubuntu/debian specific -export PATH="$PATH:/usr/lib/postgresql/9.6/bin:/usr/lib/postgresql/11/bin" +export PATH="$PATH:/usr/lib/postgresql/9.6/bin:/usr/lib/postgresql/11/bin:/usr/lib/postgresql/13/bin" initdb -V > /dev/null || exit 1 PGVER=$(psql -V | awk '{print $NF}') |