Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. Output a tar archive suitable for input into pg_restore.The plain text format is useful for very small databases with a minimal number of objects but other than that, it should be avoided. Output a plain-text SQL script file (the default).Here we use gzip ie, test.gz, We also recommend you select Custom because Using the custom format you can restore single objects from a backup. This format is also compressed by default. This is the most flexible format in that it allows the reordering of loading data as well as to object definitions. Output a custom archive suitable for input into pg_restore.Zip filestore in a specified location.Dump ODOO Database in specified format.User can select the format to dump, either custom archive, plain text SQL or tar archive.Backup ODOO Databases in a specified path.Module For backup ODOO databases and automating the backup process of ODOO. Please guide meĪvailable Odoo Backup DB/Filestore Modes: To set odoo to read the new filestore location. (Reason : I get to see full log of what is happening when we restore a huge database) I need to know how to backup and restore filestore using command line. When we restore using UI, filestore is zipped and restored properly.īut when we want to restore a database that is more than 10 GB, it is adviced to use psql dump. local/share/Odoo/filestore/dbname when we create or restore database from ui. But when restored, I am missing all icons and images attached. Psql -U rck10 -d rck_test6 -f /odoo/backups/newĮverything works fine. Sudo pg_dump -U rck10 -h localhost -p 5432 rck_test5 > /odoo/backups/new ![]() Step1 : Backup my database named rck_test5 ![]() I tried to backup and restore by database by PSQL dump.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |