OpenSSL Error with pgsql-http when running pg_regress

[olirice]

Using pgsql-http's http_<verb> functions in pg_regress tests an OpenSSL exception is thrown

select
  content
from
  http_get (
    'https://postman-echo.com/get?foo1=bar1&foo2=bar2'
  );
ERROR:  OpenSSL/3.0.13: error:16000069:STORE routines::unregistered scheme

Note that this issue is not present when running locally with

nix run .#start-server 15

and

nix run .#start-client 15

It is also not present on the hosted platform.

You can find a reproduction case in https://github.com/supabase/postgres/pull/1164/files

using nix flake check -L to run the tests

Ideally we'd solve this by closing the difference between how pg_regress runs postgres compared to nix run .#start-server 15