In this recipe, you will learn how to perform a scheduled backup of your PostgreSQL database and upload it to Amazon S3.
To complete this recipe, you will need an application with the PostgreSQL cartridge. Please refer to the Adding the PostgreSQL cartridge to your application recipe in this chapter to learn how to add the PostgreSQL cartridge. Also, you need to have the Amazon AWS account. Go to http://aws.amazon.com/, and sign up for a new account if you don't already have one.
The following are the steps to perform daily scheduled backup of your PostgreSQL database: