PostgreSQL Backup Software
Backup Software / Features / 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.
Powered with a scheduling, incremental backup, multi-threaded advanced transfer engine, online HBDrive and other features, Handy Backup seems to be one of the first-choice-solution for PostgreSQL database backup.
Version 7.6.7, built on July 6, 2015
There are some ways to make a backup of your PostgreSQL database:
That method is based on a text file generation with the SQL commands. It’s possible to reconstruct the database in the same state it was at the time of the dump. PostgreSQL provides a software utility pg_dump for this purpose (it dumps only one database and does not include dump information about roles or tablespaces).
The method does not guarantee the complete safety of your database. Some operating systems have a maximum file size limit (leads to problems when creating large files using pg_dump). For large databases, you need to find other ways to back up.
Another way for PostgreSQL backup is to make a direct copy of all database files. However, you have to stop the database server to do the backup. The connection prohibition to the server will not work because of an internal buffering.
If you try to backup only certain individual tables or databases from the appropriate files or directories, you will not be able to do so because that information is not correct without the transaction log file. Thus, the file system backups only work if you make a full database backup. Note that a file system backup may be larger than the SQL dump. However, file system backups are usually faster.
An alternative approach to backing up the file system is a hot PostgreSQL backup. You do not have to stop the database to make backups. With Handy Backup it is very easy. It does the backup job with PostgreSQL backup tools at the same time you work with the PostgreSQL database. Set the schedule for backing up and free you time!
PostgreSQL is a very popular world’s open source database. You can make backup/restore PostgreSQL database via Handy Backup. Here is a simple PostgreSQL backup schema:
Select the “PostgreSQL” in the Handy Backup menu
Follow steps to set up backup destination, scheduling, security options.
To restore PostgreSQL database , select recovery option in the File menu. Select the .hbi file and your database will automatically be restored.
There are many reasons to prefer the PostgreSQL backup function of Handy Backup among its competitors.
In addition to support for backing up to CD, backing up to DVD, and other media, you can take the advantage of storing your data in a remote secured underground shelter using our Online Backup Service.
Automatic PostgreSQL backup compression is a great feature to minimize a storage space required.
PostgreSQL backup copies can be protected with advanced encryption algorithms and a password.
You will only need a couple of minutes to set up a fully automatic PostgreSQL database backup plan.
You need to define a backup plan only once, and then the program will run backup and restore tasks automatically, on a minute to monthly basis.
Our backup program lets you back up PostgreSQL tables located on both local and remote computers without stopping them (using a hot backup technology).
You can configure Handy Backup to start as a Windows service, and it will perform your backups on time, even if you aren’t logged on.
Multi-threaded transfer engine carries out backup functions in the background with a maximum speed and a minimum system resource consumption.
See PostgreSQL backup features for more information.
PostgreSQL can satisfy the requirements of all kinds of consumers: it’s very popular among individual programmers and is also used by such companies as Yahoo!, Skype, Sony and BASF. The system isn’t managed by a single company; it’s developed by the community of companies and developers from all around the world. That’s why the PostgreSQL backup feature of Handy Backup is sure to benefit a lot of users.
PostgreSQL backup is available in two different versions of Handy Backup - Small Server and Server Network.
The setup file is common for both editions. Try free for 30 days!
Both versions will provide you with a full-featured backup, but there are some differences. Small Server is designed for a single computer: you need a running program to set the parameters for backup. Server Network option is designed for multiple computers or a backup over the network. Handy Backup installation provides a system service on the user’s machine. You can manage all the backups from the server administrator computer. This is very convenient, because users don’t need to think about PostgreSQL database backups themselves.
Professional version has built-in Database Backup plug-in you can use for backing up the PostgreSQL database through the ODBC. Learn about database backup restrictions...
More information about the prices and the options for purchasing Handy Backup is here.
Try Handy Backup right now and see how effective the PostgreSQL backup process can be!
Loading comments, please wait...
+1 (707) 703-13-11
2015/07/13 - Version 7.6.7 Released: Improved Server Backup Software Capabilities
2015/05/27 - Update to Version 7.6.5: Improved Features of Differential, Incremental and Versioned Backup
SQL Backup Script - Handy Backup VS handmade SQL backup scripts
InterBase Backup - cherish the small footprint and consumption of system resources by your database
management system? Protect the tool which brings you those!
MS Access Backups - dismiss the data loss of the Microsoft Database Management System, without stopping the service
MySQL backup - set-it-and-forget-it style copying of database tables
Backing Up FoxPro - are you into developing applications for both single and distributed architectures with the use of FoxPro? Back the thing up!
PostgreSQL Backup Features - learn more about hot backup and recovery of PostgreSQL database
SQL database backup - how to backup SQL databases.
Copyright © 2004-2015 Novosoft LLC. All rights reserved. Handy Backup software.
Back to Top