/
How to generate schema dump on BF side

How to generate schema dump on BF side

Owned by Eldiiar Duishenaliev
Apr 07, 2025

  1. Install PostgreSQL utilities on the target host.

  2. 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

  1. Make saved script executable by: chmod +x {{YourScriptName}}.sh

  2. 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.

 

Related content