Hi guys. I was trying to make a script for making backups in the shell and I shreddered something. Need help now. :)
That´s what I did:
- I made a db backup with pg_dump -Fc
- I renamed the original db in the shell by using psql
- I created a new db with the original name by using createdb in the shell
- restored dumped dbdata into the new db by pg_restore -d
The funny thing was, Odoo was using the old, renamed database, not the new one with the original name.
Now we dropped the old/renamed database and odoo wants us to setup a new database instead of use the new database with the original name. The Database exists and in pgAdmin it looks identically like before that whole operation.
Of course i restarted odoo.
Thanks
Hi Martin! I've created an Odoo module that automates backups from your Odoo, without technical knowledge. If this could help you have a look at https://www.odoo.com/forum/help-1/question/public-release-automated-backup-module-82374 there are the links to the module and a full guide. Hope this can help you :)