Able to create postgres database in command line but not in bash script

Question

I am trying to write a bash script that automates created and filling a database.

I found that I can use these commands to create a database in the command line:

sudo su postgres
psql -c 'CREATE DATABASE routing;'
exit

I see the database afterwards. However when I put these into a shell script and run it (with sudo), the database is not created. Any ideas?

score 3 · Accepted Answer · answered Aug 24 '17 at 13:32

3

after you sudo su you become another user. at this point script will stop executing, until you exit the user, then it will go on executing.

instead if you want to run something as postgres , try smth like this:

sudo su postgres <<EOF
psql -c 'CREATE DATABASE routing;'
EOF
exit

answered Aug 24 '17 at 13:32

Vao Tsun

Ok, that works... What is it about the `EOF` statements that is making it work? – wfgeo Aug 24 '17 at 13:44
https://en.wikipedia.org/wiki/End-of-file - a cosy way to specify command I want to run as postgres in multiline – Vao Tsun Aug 24 '17 at 13:46
So is the `< – wfgeo Aug 24 '17 at 13:50
yes, so if you want to run more as postgres, put it between `< – Vao Tsun Aug 24 '17 at 13:54

1 Answers1