PostgreSQL backup tools offer capabilities for backing up crucial data within such databases, ensuring data integrity and security in case of unexpected events or system failures. Among them, Handy Backup emerges as a top-tier PostgreSQL Backup Software, providing users with a comprehensive solution for seamless backup and recovery operations.
Discover the complete range of database auto backup solutions available on Windows with Handy Backup today! Download the free trial version for instant access.
Version 8.5.7 , built on September 10, 2024. 118 MB
30-day full-featured trial period
Handy Backup offers essential advantages for efficiently preserving data within PostgreSQL environments without impacting server performance while running a database engine instance. Handy Backup compatibility has been verified on PostgreSQL versions 16, 15.1, 14.6, 13.9, 12.13, 11.18, and 10.2.
Please note that for versions 10 and later, Handy Backup requires 64-bit capacity. The choice of bit depth is made during the program installation process.
Now let's delve into the powerful suite of backup tools offered by Handy Backup!
Handy Backup can preserve all database information without interrupting the database engine. All operations, including transactions, will continue seamlessly, and users backing up data do not need to stop or partially slow down the server.
Handy Backup enables users to select database backup schemas, databases, procedures, or settings to save using a tool named "PostgreSQL" for all these actions. This feature operates entirely in automated mode, seeking and saving any data selected by the user.
To leverage auto backups with maximum efficiency, users must have the ability to modify, replicate, or mirror the backed-up database or schema. Handy Backup preserves database copies in a native, readable format that is accessible for modifications and facilitates cloning and replicating backups.
Handy Backup supports SSL connection to PostgreSQL servers, ensuring secure data transmission and protecting sensitive information during backups. SSL encryption enhances data security and prevents unauthorized access. It enables users to confidently backup and restore databases while maintaining high security standards.
Handy Backup provides a user-friendly interface for creating and managing PostgreSQL backup and restore tasks. With an efficient yet easy-to-use task creation wizard, you can set up new tasks in just a few steps. Choose between simple mode for quick backup task creation or advanced mode for accessing all Handy Backup features. Control all tasks effortlessly with the same elegant GUI!
In addition to the main advantages listed before, Handy Backup offers a variety of other features to make it the most effective, efficient, and reliable PostgreSQL backup software. Discover how Handy Backup can fulfill your PostgreSQL Windows backup requirements:
Handy Backup offers various modern options for data storage, including:
* Accessing local drives on remote network machines is possible only after sharing those drives as network resources or mapping them as parts of the Windows disk system. Alternatively, you can connect to remote drives using the Server Network solution to create and maintain PostgreSQL restore dump files.
To configure an automatic backup task for a database or schema, please follow the steps outlined below:
Tip: We do not recommend selecting incremental backup for that DMBS, as it may not provide any significant benefits in terms of space and, particularly, backup time. Instead, opt for the differential backup whenever possible!
Note: You must have sufficient user privileges to use a SELECT statement for creating a backup using the provided tool.
Handy Backup saves backup data in a standard database format, allowing users to access these backups as typical PostgreSQL files for modification, exploration, or restoration purposes. Follow these steps to create a restore backup task:
Note: In advanced mode, you can change the location for restoring database backups to create a clone or mirror of your original database.
We recommend using manual backup and recovery methods only when saving a copy of an actively used database. However, for regular backups and optional restoration after accidents, you can utilize a fully automated PostgreSQL restore backup script.
In this video example, we will demonstrate how to backup a PostgreSQL database using Handy Backup. This comprehensive, step-by-step walkthrough illustrates the entire process of creating tasks for backup and restore.
Note: If you still have any questions regarding backup matters for your database system, please feel free to reach out to us via email or follow us on social networks!
With Handy Backup, you have the ability to restore your database to a location different from where the original dataset was located. By employing this technique, you can swiftly clone or mirror your backup database to as many copies as necessary.
PostgreSQL backup is available in two versions of Handy Backup - Small Business and Server Backup editions.
Both versions provide full-featured backup capabilities, but there are some differences. The Small Business edition is a complete solution for a single computer, while the Server Network edition is designed for multiple computers, enabling backup of servers and workstations over the local network.
Note: Both editions support PostgreSQL backup from a remote server using either a network name or an IP address to connect to the server. However, the Server Network solution offers additional features such as network backup to remote machines, "hot" cloning and replicating PostgreSQL, and cluster backup.