sqitchPg does not work with SCRAM authentication for PostgreSQL

I am trying to use sqitchPg (Sqitch with PostgreSQL). When I initialize my PostgreSQL cluster with initdb --auth=scram-sha-256 then Sqitch does not work and displays:

SCRAM authentication requires libpq version 10 or above

It works correctly when I initialize my PostgreSQL cluster with initdb --auth=md5.

To Reproduce

In a new directory, create shell.nix with the following content:

{ pkgs ? import <nixpkgs> {} }:

with pkgs;

let
  inherit (lib) optional optionals;

  postgresql = postgresql_11.withPackages (ps: [
    ps.pgtap
  ]);

  vscodeWithExtension = vscode-with-extensions.override {
    # When the extension is already available in the default extensions set.
    vscodeExtensions = with vscode-extensions; [
      bbenoist.Nix
    ];
  };
in

mkShell {
  buildInputs = [
      git
      postgresql
      perlPackages.TAPParserSourceHandlerpgTAP
      sqitchPg
      pgadmin
      vscodeWithExtension
    ]
    ++ optional stdenv.isLinux libnotify # For ExUnit Notifier on Linux.
    ++ optional stdenv.isLinux inotify-tools # For file_system on Linux.
    ++ optional stdenv.isDarwin terminal-notifier # For ExUnit Notifier on macOS.
    ++ optionals stdenv.isDarwin (with darwin.apple_sdk.frameworks; [
      # For file_system on macOS.
      CoreFoundation
      CoreServices
    ]);

  # Set up PostgreSQL cluster in the project diretory.
  shellHook = ''
    export PGDATA=$PWD/pgsql/data
    export PGHOST=localhost
    export PGUSER=postgres
    local PGPASSWORD=postgres
    local SOCKET_DIR=$PWD/pgsql/socket
    local LOG_DIR=$PWD/pgsql/log
    if [ ! -d $PGDATA ]; then
      echo "Initializing PostgreSQL cluster…"
      initdb --auth=scram-sha-256 --pgdata=$PGDATA --encoding=UTF-8 --no-locale --username=$PGUSER --pwfile=<(echo "$PGPASSWORD") >/dev/null
      # initdb --auth=md5 --pgdata=$PGDATA --encoding=UTF-8 --no-locale --username=$PGUSER --pwfile=<(echo "$PGPASSWORD") >/dev/null
      local CONF_PATH=$PGDATA/postgresql.conf
      echo "unix_socket_directories = '$SOCKET_DIR'" >> $CONF_PATH
      echo "listen_addresses = '*'" >> $CONF_PATH
      echo "logging_collector = on" >> $CONF_PATH
      echo "log_directory = '$LOG_DIR'" >> $CONF_PATH
      echo "log_min_messages = debug1" >> $CONF_PATH
      echo "log_connections = on" >> $CONF_PATH
      echo "log_disconnections = on" >> $CONF_PATH
      echo "log_statement = 'all'" >> $CONF_PATH
    fi
    if [ ! -d $SOCKET_DIR ]; then
      mkdir -p $SOCKET_DIR
    fi
    if [ ! -d $LOG_DIR ]; then
      mkdir -p $LOG_DIR
    fi
    export PG_LOG_PATH=$LOG_DIR/pg_ctl.log
    echo -e 'Start PostgreSQL by running:\n\tpg_ctl start -l $PG_LOG_PATH'
  '';
}

Create sqitch.conf with the following content:

[core]
    engine = pg
[deploy]
    verify = true
[rebase]
    verify = true
[engine "pg"]
    target = local_test
[target "local_test"]
    uri = db:pg://localhost:5432/

Type nix-shell
Type pg_ctl start -l $PG_LOG_PATH
Type sqitch status

NixOS / nixpkgs

sqitchPg does not work with SCRAM authentication for PostgreSQL #72781