How to decrypt the downloaded Backup of the Postgres-DB?
Solution
With the file downloaded, you can decrypt it with the following command:
cat <encrypted-backup-file> | openssl enc -md md5 -aes256 -d -pass 'pass:<encryption-key>' > <decrypted-backup-file>.gz
cat <decrypted-backup-file>.gz | gunzip -c > <backup-file-name>
Every service creates the backup according to its architecture (single vs cluster) and backup type (logical, continuous archiving, etc).
Each service provides tools that handle the data by itself. For this reason, the output of this command can be a still zipped file, POSIX tar archive, a binary file, or a plain text file.
You can also check the header of the file to decide how to decompress it.
file <backup-file-name>
Notes
For more details please visit the below MindSphere documentation:-