How to generate schema dump on BF side

Install PostgreSQL utilities on the target host.
Adjust below script (ALL PG Variables) and save in any desired location, then “cd” into that location.

#!/bin/bash
export PGPASSWORD='Please DB password here'
export PGHOST='Please DB DNS hostname here'
export PGDATABASE='Please maintenance DB name here'
export PGUSER='Please DB Admin username here'
export TMPDIR=/home/$(whoami)

rm -f $1.sql || true

pg_dump -n $1 -f $1.sql --verbose

Make saved script executable by: chmod +x {{YourScriptName}}.sh
Execute script with nohup utility

Execution example: nohup {{YourScriptName}}.sh {{fullSchemaName}} > db.log &

copy schema dump to some S3 bucket, generate pre-signed URL and share with requestor.