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