We are excited to bring you the latest feature on Backup Ninja, a simple and secure backup service for files, folders and databases like MySQL, Postgresql, MongoDB, Percona, Timescale, and MariaDB. In this release, we would like to introduce the all new automated PostgreSQL incremental backup, restore and point-in-time recovery(PITR) feature for you to create and manage PostgreSQL incremental backup in a scriptless way using a simple GUI.
Point-in-time recovery(PITR) allows an administrator to recover data changes up to a point time which is not only crucial for faster recovery, but the backup recovery will have the last known good point of the data. PITR for PostgreSQL requires backing up live database files and archiving the Write Ahead Log (WAL) files. A WAL file logs any transactions like updates, deletes, and creation did to the database. If you want to restore the state of a database to a point in time, the WAL file segment can be used. You will need an experienced DBA to write a bunch of scripts, and cron jobs to create, manage and schedule PostgreSQL incremental backups, and this creates additional overhead to your DBA.
Backup Ninja solves this problem with the automated PostgreSQL incremental backup feature. Once you have the Backup Ninja agent installed on your server, you can schedule a backup for PostgreSQL incremental backup in just four steps using the same familiar interface. Enable PITR with just a toggle button and specify the WAL archive file location and follow the on-screen instructions to schedule the PostgreSQL point-in-time recovery incremental backups in no time.
Set the schedule for the full backup and incremental backup under the WAL Archive Schedule without manipulating scripts or other configuration files. You can easily edit the schedule settings at any time using the edit window.
View your full and incremental backups created for the created schedule. If there are no changes made, Backup Ninja skips the incremental backup for that time; these details are clearly shown when you view the details of the backup.
To restore either the incremental backup or the full backup, click on the more action and click restore. You will see a screen to confirm the details of the archived backup to be restored. Complete the restore process with just a click on the ‘Restore Backup’ button.
We believe the PostgreSQL incremental backup feature and automatic restore will ease your PostgreSQL backup management and facilitate point-in-time recovery without the need for tedious scripts. Stay tuned in for more updates from the Backup Ninja team.