PostgreSQL Backup and Recovery

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 7.7.9, built on 22 April, 2016
55.2 MB

Key Principles of Effective 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

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.

Schedule Backup
MySQL Synchronization

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 and differential 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.

See PostgreSQL database backup features for more information.

PostgreSQL Backup Features


Recommended Solution

Handy Backup Small Server

Version 7.7.9, built on 22 April, 2016. 55.2 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup for Small Business

The Small Server 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 on the Step 2.
  2. If you do not have a PostgreSQL configuration, create a new by selecting an option allowing it.

PostgreSQL Configuration

  1. To create a new configuration, enter your DBMS connection parameters into the dialog.
  2. When you have a configuration to back up data from it, choose it and select particular data.
  3. On the Step 3, select a data storage for your PostgreS backup table set.
  4. Choose a backup type on the Step 4, setting up timestamps and versioned 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.


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.

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!

Download Handy Backup

Version 7.7.9, built on 22 April, 2016
55.2 MB

Licensing information

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

Both versions will provide you with a full-featured backup, but there are some differences. Small Server is designed for a single computer, Server Network option is designed for multiple computers or a backup over the network.


See also:


Loading comments, please wait...

0 comments

    Who uses our backup software?