O'Reilly logo

Learning Heroku Postgres by Patrick Espake

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

Chapter 4. PG Backups

Backups are important at any level. Failures are possible to occur at any system that uses the database. It may be an accidental failure, data corruption, or hardware-related. You need to perform actions anticipating failures and take steps to ensure data integrity. Therefore, Heroku offers an add-on called PG Backups that allows you to create and restore backups of your Postgres database hosted on Heroku, and also to import and export data.

In this chapter, you will learn how to use the features that this add-on provides.

This chapter will cover the following topics:

  • Plans
  • Installing the add-on
  • Changing the plan
  • Creating a backup
  • Listing backups
  • Downloading a backup
  • Deleting backups
  • Restoring from a backup
  • Importing databases
  • Exporting ...

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