Lite PostgreSQL Backup GUI Tool

PostgreSQL Backup by Pranas.NET is a Windows GUI tool for automating backups PostgreSQL database.

If you use PostgreSQL to store your data, you probably thought about some convenient GUI tool for creating regular backups. PostgreSQL Backup is designed to work on Windows and backup your local or remote database according to the schedule. It also zips, encrypts and sends backups to a folder, FTP, Dropbox, Box, Google Drive, MS OneDrive, Amazon S3 or Windows Azure Storage.

In this post, we are going to show how to set this tool up and run scheduled backups.

Connect to PostgreSQL

First, let’s download and run the tool. After you started PostgreSQL Backup click “Connect to PostgreSQL Server” button. In the opened window enter your PostgreSQL’s user name and password:Connect to PostgreSQL Server

Click “Test Connection” to make sure that the connection with the server is established:PostgreSQL Test Connection

Select Databases for Backup

After the connection is established you need to choose the databases which you are going to backup. You can find a list of databases in the column on the left side. PostgreSQL Databases

Configure Backup Destination

PostgreSQL Backup can send your backup to several destinations like a local folder, FTP, Dropbox, Box, Google Drive, MS OneDrive, Amazon S3 or Windows Azure Storage. To select your preferred storage click “Add backup destination” link: PostgreSQL Backup Destination

Set up a Schedule for Making PostgreSQL Backups

The last step is to set up a PostgreSQL database backup schedule. Check off “Schedule this job” and click “Advanced backup schedule” button. In the opened window make all necessary setting and press “Save & Close”. PostgreSQL Advanced Backup Schedule

Run PostgreSQL Backups

To start scheduled backup you need to save all the settings by pressing Save button. If you want to run the backup immediately press “Run Now” button:PostgreSQL Backup Save and Run

PostgreSQL Job Execution

That’s all.

Here we didn’t mention email notifications, tons of advanced options and execution log that make this product a must-have utility for every PostgreSQL administrator.

 

[Total: 1    Average: 5/5]