How to Backup PostgreSQL to FTP Server

How to Backup PostgreSQL to FTP Server (logo)It’s well known that you can perform PostgreSQL database backup with the help of pg_dump utility. But is it the best way to make PostgreSQL backups on a regular basis? What if you need to make PostgreSQL backups every six hours and send them to FTP Server? How would you do that and how much time would you spend every day to perform such scenarios? With the help of PostgreSQL Backup, you can create a backup job, which will make PostgreSQL database backups according to your schedule and send them to FTP Server automatically. All you need is to download PostgreSQL Backup and few minutes of your time to tune the backup job.

Backup PostgreSQL to FTP Server

  1. Launch PostgreSQL Backup and select all PostgreSQL databases which you need to backup. You can find them in the box on the left side. Backup PostgreSQL to FTP Server (databases)
  2. Press “Add backup destination” link and select “FTP Server” from the list.Backup PostgreSQL to FTP Server (destination) Specify your FTP Server “Host address”, “Username” and “Password”. To check all settings press “Test” and then click “Save & Close” to save all configurations.Backup PostgreSQL to FTP Server (test)
  3. To create PostgreSQL database backup schedule check off “Schedule this job” and click “Advanced backup settings”. Backup PostgreSQL to FTP Server (schedule) In the opened window specify backup schedule and press “Save & Close”. Backup PostgreSQL to FTP Server (backup settings)
  4. The backup job which will make schedule PostgreSQL database backups and send them to FTP Server is ready. Click “Save” to save and run your backup job or press “Run Now” to make PostgreSQL database backup immediately. Backup PostgreSQL to FTP Server (run now)
[Total: 1    Average: 5/5]

Leave a Reply

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