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

devnull · Accepted Answer · 2013-09-16 04:50:53Z

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.)

answered Sep 16, 2013 at 4:50

devnull

124k33 gold badges247 silver badges234 bronze badges

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

2 Comments

nish Over a year ago

this works but the execution of the command does not stop after the database gets created!! How to stop it after the creation of the database?

nish Over a year ago

this works but the execution of the command does not stop after the database gets created!! How to stop it after the creation of the database?

Collectives™ on Stack Overflow

postgres commands working in shell but not in python script

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