In the diploma thesis, we discuss the creation of backups of PostgreSQL databases and the restoration of databases in the event of a data incident.
We demonstrate the creation of backup copies and the restoration of databases in a variety of ways that meet the needs of our client.
First, we look at backup strategies and client requirements. Then we take a closer look at the ''Veeam Backup & Replication'' tool. This tool is designed to create backups of various physical or virtual machines and its applications.
We demonstrate the creation of backup copies with commands and methods that are already built into the PostgreSQL database. These we then automate using a task scheduler and the Cron tool.
In the following, we demonstrate the creation of backups using the "Veeam" tool, where the backup copy was created using scripts and the "Veeam agent for Linux", which is one of the components of the "Veeam" tool.
We also discuss the restoration of the PostgreSQL database. We show three different methods of database restoration, namely database restoration with a command built into the PostgreSQL database, database restoration using ''Veeam'' tool on a Windows server, and point-in-time restoration using ''Veeam'' tool, that enables PostgreSQL databases on Linux servers and ensures the shortest possible database recovery time.
Finally, we compared the creation of backup copies with and without the use of the "Veeam" tool.
|
