Manual Recovery

Preferred method is using ogion itself - see CLI Reference.

If you need to restore manually without ogion, follow the steps below.

Recovery Process

Download the backup file from your cloud provider (GCS, S3, Azure).

You need the age private key that matches the public key used during backup.

age -d -i /path/to/key.txt -o backup.sql.lz backup.sql.lz.age

1	`lzip -d backup.sql.lz`

This produces the final backup file (e.g., backup.sql).

Restore using psql:

psql -h localhost -p 5432 -U postgres -d database_name < backup.sql

Restore using mariadb:

mariadb -h localhost -P 3306 -u root -p database_name < backup.sql

Copy the file back:

1	`cp backup_file /destination/path`