password with special characters is difficult to connect with

[gregwebs]

The Rust URL encoding will encode the user password to https://url.spec.whatwg.org/#userinfo-percent-encode-set

However, PG itself points to this as the encoding: https://datatracker.ietf.org/doc/html/rfc3986#section-2.1

What works for me is to use jq -sRr '@uri' or more specifically

#!/usr/bin/env bash
set -euo pipefail

PGPASSWORD="${PGPASSWORD:-''}"
PGHOST="${PGHOST:-'localhost'}"
PGPORT="${PGPORT:-5432}"
password="$(echo -n "$PGPASSWORD" | jq -sRr '@uri')"
if echo $PGHOST | grep '/' >/dev/null ; then
  host='localhost'
else
  host="$(echo -n "$PGHOST" | jq -sRr '@uri')"
fi
echo "postgres://$PGUSER:${password}@${host}:$PGPORT/$PGDATABASE?sslmode=disable"

[gregwebs]

What I am doing is not passing any PG args to datanymizer other than --dbname as the url and also giving the url to pg_dump with pg_datanymize --dbname "$DATABASE_URL" -- $DATABASE_URL

[gregwebs]

hmm, also saw that strategy not work in a different case and reverted back to CLI args and it worked there.