Runkit and too old Postgres

[Wouter Hendriks]

I've used runkit to get the backup of a server locally with:

runkit restore-server --nodocker --fast --archive 20250319T094445-webwerf-do-ams3-2 wvuaw-20250319

However when I run it:

 runkit @wvuaw-20250319 wh console

I'm getting:

[2025-03-19T17:50:17.736Z] Starting WebHare 5.7.1 in /Users/wouter/whrunkit/wvuaw-20250319/whdata/ at http://127.0.0.1:52290
[2025-03-19T17:50:17.761Z] webserver: Starting HareScript webserver
[2025-03-19T17:50:17.776Z] webserver: Could not load webserver management script, terminating webserver
[2025-03-19T17:50:17.779Z] webserver: Exited with error code 0
[2025-03-19T17:50:17.779Z] webserver: Throttling, will restart after 1 seconds
[2025-03-19T17:50:17.796Z] database: This database requires PostgreSQL version 11. Please install it and point the WEBHARE_PGBIN environment variable to it
[2025-03-19T17:50:17.796Z] database: You may be able to install it with 'brew install postgresql@11' or you may need to download binaries directly
[2025-03-19T17:50:17.797Z] database: Exited with error code 1
[2025-03-19T17:50:17.797Z] database: Exit is considered fatal, shutting down service manager
[2025-03-19T17:50:17.798Z] harescript-compiler: Exited with error code 207

Tried setting WEBHARE_PGBIN and then run:

WEBHARE_PGBIN=/opt/homebrew/opt/postgresql@16/bin runkit @wvuaw-20250319 wh console

But that gets me:

[2025-03-19T17:57:25.322Z] database: 2025-03-19 18:57:25.322 CET [5566] FATAL:  database files are incompatible with server
[2025-03-19T17:57:25.323Z] database: 2025-03-19 18:57:25.322 CET [5566] DETAIL:  The data directory was initialized by PostgreSQL version 11, which is not compatible with this version 16.8 (Homebrew)

Any idea what the fix is without needing to download everything again?

[Arnold Hendriks]

> This database requires PostgreSQL version 11. Please install it and point the WEBHARE_PGBIN environment variable to it

why are you explicitly giving it version 16?

[Wouter Hendriks]

Because I can't install 11

mac:opt wouter$ brew install postgresql@11
==> Downloading https://formulae.brew.sh/api/formula.jws.json
==> Downloading https://formulae.brew.sh/api/cask.jws.json
Error: postgresql@11 has been disabled because it is not supported upstream! It was disabled on 2024-11-09.

[Arnold Hendriks]

try 

mkdir -p ~/postgresarchive/11
cd ~/postgresarchive/11/
curl -O https://files.webhare.com/postgres/mac/postgresql-11.21-1-osx-binaries.zip
unzip postgresql-11.21-1-osx-binaries.zip
export WEBHARE_PGBIN=~/postgresarchive/11/pgsql/bin

[Wouter Hendriks]

Excellent, works perfectly, thanks!