O'Reilly logo

OpenShift Cookbook by Shekhar Gulati

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performing scheduled PostgreSQL database backups

In this recipe, you will learn how to perform a scheduled backup of your PostgreSQL database and upload it to Amazon S3.

Getting ready

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.

How to do it…

The following are the steps to perform daily scheduled backup of your PostgreSQL database:

  1. Go to https://console.aws.amazon.com/s3/home, and create a new bucket to store your database backups.
  2. Add ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required