Hi all,

When I create a database dump in python script and if there are some errors 
(user_name is not correct, db_name doesn't exist or something else) I need to 
send e-mail notification to admin. How can I handle these errors?

Example:
----------------------------------------------------------------------------#!/usr/bin/python
import os

os.system("pg_dump -U user_name -i -F c -v db_name -f file_name.backup") 
print "%s backup complete" % ("Database XXX")
----------------------------------------------------------------------------

I tried to use, but it doesn't work.

----------------------------------------------------------------------------
#!/usr/bin/python
import os

try:
    os.system("pg_dump -U user_name -i -F c -v db_name -f file_name.backup")
    print "%s backup complete" % ("Database XXX")
except os.error:

    # ...
    # here sending e-mail if there is an error of backing up
    # ...

    print "Backup error %s" % error


--
Vadim


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to