I'm not familiar with PostgreSQL database administration , so I figured I might ask for help from someone more knowledgeable on the subject.

Here are the requirements:

1. This program should take database backup every night of our Postgresql DB

2. Upload the backup file to FTP location

3. Send email after successful backup and upload