DEV Community

Dmitry Romanoff
Dmitry Romanoff

Posted on

3

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)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay