Desenvolvimento de um sistema de backup e restauração com armazenamento seguro em nuvem

Abstract

This work presents the development and evaluation of a data backup and restoration system for PostgreSQL databases, with emphasis on information security and the use of cloud services. The proposed solution includes the generation of full backups, file compression, AES-256 encryption, and integrity verification through the SHA-256 algorithm. The resulting artifacts are automatically uploaded to Azure Blob Storage according to a user-defined backup policy executed by the Cron scheduler. A graphical interface was also implemented to support assisted restoration, allowing the recovery of data from both local files and the cloud. The experiments demonstrated the system’s ability to restore different versions of the database, including the recovery of backups generated on a Linux environment into a PostgreSQL instance running on Windows 11, highlighting portability and consistency in data recovery across heterogeneous environments. The results indicate that the solution provides a secure, reproducible, and technically feasible workflow for data protection and restoration.