You do not need to install anything on your PostgreSQL database server. Kyplex Snapshot connects to your PostgreSQL database server directly over the Internet and backups all required data. You just need to provide the credentials needed to get read access to your database. Kyplex Snapshot will require write access permission only if you need to use automatic recovery feature.
If your PostgreSQL database server is protected by the firewall or your database server allows only local connections, Kyplex backup service can tunnel database access request using SSH protocol.
In addition, using the built in file versioning mechanism and interactive diff, you can actually see what was really changed in your database and apply to your database only required changes.
Using the Kyplex management you can easily select individual tables or full backups to restore the whole database. Everything is done in automatic way.
By default, Kyplex makes daily snapshots of your PostgreSQL database. Our system saves back backups for your database for 1 week (7 backups). In case you need to recover the whole database or just one table you can easily do it using the Kyplex management console.
We backup and compress your database to reduce disk size. This method allows us to save space and host more versions of your files. As a result you pay less for more backups!
Backup File Format
It is pure SQL file. Each file is a different table. You can simply download it and execute SQL queries in your favorable database management application to recover a table.
Multiple databases supported
Kyplex Snapshot supports backup and recovery functionality for multiple databases. It can perform MySql backup and recovery, Postgresql backup and recovery, and MS SQL Server backup and recovery operations.