How To Restore Your PSQL DataBase For Odoo
Method 1:
Backup:
Basically Odoo have a good frond end tool for download Database backups.
just click on the backup buitton
If you set master password it will ask master password too. then just click on the “Backup” Button.
It will start downloading.
Restore:
Click the “Restore Database” button. (Nikhilkrishnan: IMG-1)
Choose the .zip file that we already downloaded from the backup.
Before restoring we must ensure that the new server with same odoo Version and addon lists. Click the Continue button. Backup process completed successfully.
Method 2:
Backup:
This link will help you to take backups
https://www.odoo.com/forum/help-1/question/how-to-setup-a-regular-postgresql-database-backup-4728.
Restore:
sudo su — postgres
psql template1
ALTER USER user_name with SUPER USER;
createdb <database> -T template1 -U <DB user>-h localhost
zless <dbbackup.sql.tar.gz> | psql <database>
Now open your <ip_address:8069> select your DB. and enjoy..!!
By
Nikhilkrishan