In this guide, we will cover the steps required for restoring the Odoo database backup file into a new database.
Decompress the Snapshot
The database backup file will probably be compressed to save disk space, so you need to decompress it first.
Here's how to decompress the .tar.gz file:
tar -xzf psql_backup.tar.gz
Here's how to decompress the .gz file:
Note: change the psql_backup to the actual name of the compressed backup file.
Create the Database in PostgreSQL
Switch to the postgres linux user.
sudo su postgres
Enter the PostgreSQL shell.
Create a new database:
CREATE DATABASE db_name;
Note: change db_name to a relevant database name.
Edit the Backup File
Now you need to open the backup file and replace the old database name with the new one (db_name in our case).
Note: change the psql_backup.sql to the actual name of the uncompressed backup file.
The name should be in the first 5-6 lines of the SQL file. When you're done, save the file and close it.
Restore the Backup
Once you have changed the name in the backup file, you can restore it into the newly created database:
psql db_name < psql_backup.sql