Copy database with python..

[Paul McNett]

Abandoned wrote:

> Hi.
> I want to copy my database but python give me error when i use this
> command.
> cursor.execute("pg_dump mydata > old.dump")
> What is the problem ? And how can i copy the database with python ?


You are just going to have to give us more to go on. Please post the 
entire traceback of the error that you see (copy/paste it from your 
terminal).

You can't issue system commands using the cursor's execute() method and 
expect that to work. execute() is for executing SQL, DML, or DDL, not 
for doing shell stuff.

Try:

import os
os.system("pg_dump mydata > /tmp/old.dump")

but I'm not versed in postgressql, so this probably won't work exactly 
as written. You'd need to run that code from the server hosting the 
postgresql database.


> Note: The database's size is 200 GB

Well, then you may want to make sure you have enough room on the target 
volume before trying to dump the file! Note that the dump file could 
conceivably be much larger (or much smaller) than the database itself.


-- 
pkm ~ http://paulmcnett.com