DEV Community

Dmitry Romanoff
Dmitry Romanoff

Posted on

How to run psql script in the background?

cat run_my_sql_script_background.sh

#!/bin/bash

CURRENTDATE=`date +"%Y%m%d_%H%M%S"`

OUTPUT_FILE="./outp/trace_${CURRENTDATE}.out"

export PGPASSWORD='********'

nohup psql -h my_hostname -U my_db_user -d my_db_name -a -f my_sql_script.sql > ${OUTPUT_FILE} 2>&1 < /dev/null &
Enter fullscreen mode Exit fullscreen mode

Top comments (0)