PostgreSQL Backup and Recovery Tool
Handy Backup is the perfect solution for PostgreSQL backup and recovery is an important factor of data safety for PostgreSQL databases. Handy Backup is the perfect solution for it, allowing hot backup of your data without PostgreSQL database stopping. Let us reveal all possibilities of PostgreSQL auto backup under Windows with Handy Backup!
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
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.
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.
Friendly Graphical User Interface for Task Creation and Control
With Handy Backup, you can create new PostgreSQL backup and restore tasks in a few steps with an efficient but easy-to-use task creation wizard. Turn it in a simple mode for quick backup task creation, or in advanced mode for accessing all Handy Backup features. Control all tasks with the same elegant GUI!
Other Features of PostgreSQL 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:
Where to Save a PostgreSQL Restore SQL File?
Handy Backup provides many modern options for data storage, including:
* You can access local drives on remote network machines only after sharing those drives as network resources or mapping as parts of Windows disk system. As an alternative, you can connect to remote drives by using the Server Network solution for making and keeping PostgreSQL restore dump files.
Version 8.3.2, built on October 6, 2021. 112 MB
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:
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!
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
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. To make a PostgreSQL restore backup task, please follow the next steps:
Note: In advanced mode, you can change the PostgreSQL backup restore location, to make a clone or a mirror of your original database.
We are recommending using only manual PostgreSQL backup and recovery methods when you saving a copy of some database in active use. However, for regular backup and optional restoration after some accident, you can utilize a fully automated PostgreSQL restore backup script.
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 restore.
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.
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!
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, “hot” cloning and replicating PostgreSQL, and using cluster backup.