Backup and Restore

<< Click to Display Table of Contents >>

Navigation:  Database servers > PostgreSQL >

Backup and Restore

SQLBackupAndFTP

We have purchased, used and can recommend SQLBackupAndFTP Standard.

 

"SQLBackupAndFTP is a backup solution for SQL Server, MySQL, and PostgreSQL databases that performs scheduled full, differential, and transaction log backups, supports incremental backups for MySQL and PostgreSQL, backs up files and folders, compresses and encrypts backup files, stores them locally, on a network, FTP/SFTP server, or in the cloud (Amazon S3, Google Drive, OneDrive, Dropbox, and more), automatically removes old backups based on retention policies, and sends email notifications on backup success or failure."

 

The Standard version can be configured to backup to OneDrive, Google Drive, Dropbox, Box and FTP/SFTP server accounts. You can authorize any account as the backup destination. You do not need to be logged into any of the online services on the local PC.

 

Tutorial

Here is a tutorial on scheduling backups:

 

https://sqlbackupandftp.com/postgresql-backup