The easiest way to make PostgreSQL backup is to use SQLBackupAndFTP tool. Simply speaking, a database backup is a typical copy of data. When the original information is destroyed, you can use the backup to reconstruct destroyed records. The copy includes crucial parts of your database, such as the managed file, archive logs, and data files – structures described further in this section. In the event of a media failure, your postgres backup is the key to properly recovering your data. More…

One of the most common ways how to make PostgreSQL database backup is to use pg_dump utility. But is it the best way how to make backups according to your schedule and then send them to the specified destination? With the help of SQLBackupAndFTP, you can create a backup job which will make scheduled backups and then send them to Local or Network Folder. More…

The easiest way to backup PostgreSQL on Windows is to use SQLBackupAndFTP tool. Making PostgreSQL backups on a regular basis is the best way to protect your databases from the disaster. Database disaster prevention is one of the biggest pains in the life of every DBA. Data from databases are transforming day-to-day, gradually expanding the size of the latter. Naturally, there is no excellent method to avoid database corruption, but there exist a few functional tips that can show you how to bring the possibility to the minimum. More…

The easiest way to backup PostgreSQL database is to use SQLBackupAndFTP tool. Database failure avoidance is one of the most troubles in the life of each DBA. Data from a database are changing every day, slowly growing. Naturally, there is no perfect strategy to prevent database corruption, but there are a few functional steps that can assist you to bring the danger to a minimum. More…

How much time is it usually takes to make PostgreSQL database backups and then move them to OneDrive? Is your method convenient and fast? Do you know that you can make PostgreSQL databases backups and send them to OneDrive in two minutes? You can backup PostgreSQL to OneDrive with the help of the third-party tool like SQLBackupAndFTP. More…

The best way to create PostgreSQL database backups is to use the backup tool like SQLBackupAndFTP. All PostgreSQL users knew that to protect your databases from the disaster you need to make regular PostgreSQL backups. With the help of SQLBackupAndFTP, you can create a backup schedule according to which the backups will be performed and select a place where to store your backups. More…

SQLBackupAndFTP tool is the easiest way to make PostgreSQL backup on a regular basis. Scheduled PostgreSQL backup is the best way to protect your PostgreSQL databases from the disaster. PostgreSQL Database disaster prevention is one of the largest troubles in the life of each DBA. Data from a database are transforming every day, slowly expanding the size of the latter. Obviously, there is no ideal strategy to stop database corruption, but there are some practical methods that can help you to bring the danger to a minimum. More…

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 SQLBackupAndFTP. You can create a backup job just in a few minutes. More…

It’s well known that you can make PostgreSQL database backup with the help of pg_dump utility. From the one hand, it is really easy, but from another, you can not make your backups regularly. To create scheduled database backups you can use SQLBackupAndFTP, it also uses pg_dump and includes a lot of useful features which make your life easier. Assume you need to make PostgreSQL database backup twice a day and send them to Google Drive, how are you going to do it? You can do it in a few simple steps using SQLBackupAndFTP utility. More…

Nowadays more and more users prefer to store their PostgreSQL backups in the clouds. There are many ways of sending them, lest’s say to Dropbox, but is your method convenient and simple enough? Anyway, using SQLBackupAndFTP you can perform PostgreSQL backup and send it to Dropbox in just a few minutes. More…