PostgreSQL Backup and Recovery Tool

PostgreSQL Backup and Recovery

Handy Backup is the perfect solution for PostgreSQL backup and recovery. It allows hot backup of your data without PostgreSQL database stopping. Let us reveal all possibilities of PostgreSQL auto backup under Windows with Handy Backup!

Download Handy Backup

Version 8.1.2, built on 21 February 2020
106 MB

Key Principles of Efficient PostgreSQL Backup Tools

Handy Backup provides some crucial advantages for perfectly saving PostgreSQL data without slowing down a routine job on the server running a PostgreSQL database engine instance.

PostgreSQL Hot Backup

PostgreSQL Hot Backup

Handy Backup can save all the database information without stopping the database engine. All operations will continue (including transactions), and a user backing up data does not have a need to stop or partially slow down the server.

Automatic Data Selection

Handy Backup allows selecting PostgreSQL backup schema, databases, procedures or settings to save using a tool called "PostgreSQL" for all these actions. This action works completely in automated mode, seeking and saving any data selected by a user.

Automatic PostgreSQL  Data Selection
PostgreSQL Replication, Mirroring and Cloning

Using PostgreSQL Copies for Replication, Mirroring and Cloning Databases

To utilize PostgreSQL auto backups with a peak efficiency, a user must have a possibility to change, replicate or mirror the database or schema backed up. Handy Backup saves PostgreSQL copies in a native, readable format available for changing, and allows cloning and replicating backups.

Other Features of SQL Backup Windows Applications with Handy Backup

In addition to main advantages listed before, Handy Backup provides some other features for making it effective, quick and reliable PostgreSQL backup software:

  • A lot of storage media available, including local drives, NAS, FTP and cloud services;
  • Scheduling backups by a period or an event such as logon/logoff or plugging a USB drive;
  • Full, incremental, differential and mixed backup, with timestamps and versioned backups;
  • Different methods of notifying users about tasks performed, including emails and reports;
  • Control procedures, from starting as a Windows service to running other apps with a task.
PostgreSQL Backup Features

Recommended Solution

Handy Backup Small Business

Version 8.1.2, built on 21 February 2020. 106 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup for Small Business

The Small Business solution can backup, restore, compress, encrypt, clone and mirror your PostgreSQL databases and any other data on a single server. Free 30-days trial version!

How to Backup PostgreSQL Database in Windows with Handy Backup

To create a task for automatic backup database or schema, please follow the steps described here:

  1. In Handy Backup, create a new backup task. Select PostgreSQL in the Database group on Step 2.
  2. If you do not have a connection to PostgreSQL, create a new by selecting an option allowing it.
PostgreSQL Configuration backup
  1. To create a new connection, enter your DBMS connection parameters into the dialog.
  2. Open an existing connection and select PostgreSQL tables for backup inside it.
  3. On Step 3, select a data storage for your PostgreS backup table set.
  4. In advanced mode, choose backup type on Step 4. Also, set up timestamps and versioned backup keeping if you need.

An advice: We are not recommending selecting PostgreSQL incremental backup, as it can give up to no bonus in terms of space and, especially, time used for backups. Use the differential backup instead whenever it is possible!

  1. Proceed to create other task parameters, as described in the User Manual for backup tasks.

Note: You must have a sufficient user privileges to use a PostgreSQL SELECT statement for creating PostgreSQL backup with the tool provided.

How to Restore PostgreSQL Backup

PostgreSQL Restore

Handy Backup saves PostgreSQL backup data as a typical database, and users can open these backups as the standard PostgreSQL files, to modify, explore or restore the information.

In addition, Handy Backup allows creating a restoration task, with a procedure changing only by a little from a backup task.

Video Tutorial: PostgreSQL Database Backup

In this video example, we will show how to backup PostgreSQL database with Handy Backup. It is a complete step-by-step walkthrough that shows an entire process of creating tasks for PostgreSQL backup and recovery.

Note: If you still have some questions about PostgreSQL backup matters, please do not bother to ask us by email, of follow us in social networks!

Replicating and Cloning PostgreSQL Databases

With Handy Backup, you can restore your database to another place than the original dataset was located. Using this technique, you can quickly clone or mirror your PostgreSQL backup database to as many copies as you need.

Download Handy Backup

Version 8.1.2, built on 21 February 2020
106 MB

Try the automated PostgreSQL backup feature with Handy Backup on a 30-days free trial period, downloading a newest version of Handy Backup immediately from our website!

Licensing information

PostgreSQL backup is readily available in two versions of Handy Backup - Small Business and Server Network editions.

Both versions will provide you with a full-featured backup, but there are some differences. The Small Business is a complete solution for a single computer, and the Server Network edition is a solution for multiple computers, allowing backing up servers and workstations over the local network.

Note: Both editions allow PostgreSQL backup from a remote server by using either a network name or an IP to connect to a server. Still, the Server Network solution allows such additional things as network backup to remote machines, cloning and replicating servers on-the-flight, and using cluster backup.

0 comments

    Who uses our backup software?