How to Backup PostgreSQL to Amazon S3

How to Backup PostgreSQL to Amazon S3 (logo)How do you make your PostgreSQL database backups, with the help of pg_dump utility or in any other way? Do you prefer to store your backup in the cloud, like Amazon S3? How much time do you usually spend every day to make your database backup and send them to Amazon S3? It is really very easy to backup PostgreSQL to Amazon S3 with the help of PostgreSQL Backup. You can create a backup job just in a few minutes.

How to Backup PostgreSQL to Amazon S3

Follow this simple steps to create a backup job which will make PostgreSQL backups according to your schedule and send them to Amazon S3.

  1. Start PostgreSQL Backup, after you have downloaded  and installed it and check off those databases which you are going to backup. How to Backup PostgreSQL to Amazon S3 (databases)
  2. Select a backup destination by pressing “Add backup destination” and choose “Amazon S3”. How to Backup PostgreSQL to Amazon S3 (destinations) Specify “Access key”, ” Secret Key” and “Bucket”. Then click “Test” to check the connection to your Amazon S3 account. Press “Save & Close” to apply all settings. How to Backup PostgreSQL to Amazon S3 (code)
  3. To create a backup schedule tick “Schedule this job” and select “Advanced backup schedule”. How to Backup PostgreSQL to Amazon S3 (schedule) Make all necessary  backup schedule settings and click “Save & Close”. How to Backup PostgreSQL to Amazon S3 (backup settings)
  4. Everything is ready to start your PostrgreSQL backup job. To run a backup immediately click “Run Now” or press “Save” to start making your backups according to the schedule.How to Backup PostgreSQL to Amazon S3
[Total: 2    Average: 4/5]

Leave a Reply

Your email address will not be published. Required fields are marked *