Unable to run a postgresql script from bash

Question

I am learning the shell language. I have creating a shell script whose function is to login into the DB and run a .sql file. Following are the contents of the script -

#!/bin/bash
set -x

echo "Login to postgres user for autoqa_rpt_production"
$DB_PATH -U $POSTGRESS_USER $Auto_rpt_production$TARGET_DB -p $TARGET_PORT

echo "Running SQL Dump - auto_qa_db_sync"
\\i auto_qa_db_sync.sql

After running the above script, I get the following error

./autoqa_script.sh: 39: ./autoqa_script.sh: /i: not found

Following one article, I tried reversing the slash but it didn't worked.

I don't understand why this is happening. Because when I try manually running the sql file, it works properly. Can anyone help?

mkf · Accepted Answer · 2013-10-01 19:24:25Z

4

#!/bin/bash
set -x

echo "Login to postgres user for autoqa_rpt_production and run script"
$DB_PATH -U $POSTGRESS_USER $Auto_rpt_production$TARGET_DB -p $TARGET_PORT -f auto_qa_db_sync.sql

The lines you put in a shell script are (moreless, let's say so for now) equivalent to what you would put right to the Bash prompt (the one ending with '$' or '#' if you're a root). When you execute a script (a list of commands), one command will be run after the previous terminates.

What you wanted to do is to run the client and issue a "\i ./autoqa_script.sh" comand in it.

What you did was to run the client, and after the client terminated, issue that command in Bash.

You should read about Bash pipelines - these are the way to run programs and input text inside them. Following your original idea to solving the problem, you'd write something like:

echo '\i auto_qa_db_sync.sql' | $DB_PATH -U $POSTGRESS_USER $Auto_rpt_production$TARGET_DB -p $TARGET_PORT

Hope that helps to understand.

edited Oct 1, 2013 at 19:24

answered Oct 1, 2013 at 18:50

mkf

7103 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1305398 Over a year ago

@ mkf that really helped a lot. but just for curiosity what was going wrong with the approach that I was trying. Can you please explain?

mkf Over a year ago

@user1305398 I have added an explanation to my post.

Collectives™ on Stack Overflow

Unable to run a postgresql script from bash

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related