postgres commands working in shell but not in python script

Question

I am trying to create a postgres database, using a dumpfile, from a python script.

Following is the code I tried:

cmd='cat dump.sql.gz | zcat - | PGPASSWORD=my_password psql -d voylla_solr -h localhost -p 5432 -U user_name'
args = shlex.split(cmd)
p=subprocess.Popen(args)
p.wait()

I also tried using a different command:

cat dump.sql | PGPASSWORD=my_password psql -d voylla_solr -h localhost -p 5432 -U user_name

EDIT* : I used the following command:

subprocess.Popen("zcat dump.sql.gz | PGPASSWORD=my_password psql -d voylla_solr -h localhost -p 5432 -U user_name", shell=True);

It works, but it does not stop after the creation of the database. How can I stop its execution after the database os created?

Both of these commands are working in command line, but not in the python script. What am I doing wrong

Answer 1

You could simply say:

subprocess.Popen("zcat dump.sql.gz | PGPASSWORD=my_password psql -d voylla_solr -h localhost -p 5432 -U user_name", shell=True);

(Also refer to this.)