Database backup and restore

Hello, the menu bar canceled the operation of the database after update 4.8. Now I am a little confused about how to operate the backup and restore of the database.
If the system is used for a long time, a lot of data will be generated, which will affect the query speed.
Tryton has no archiving mechanism.File those completed orders?
Thank you very much!


You should use the postgresql utilities to do that: pg_dump and pg_restore.

It shouldn’t but you might have to tune the index your database is using when you encounter a slow query. Take a look at the postgresql wiki article about EXPLAIN / ANALYZE it might help you when you will have the issue.

Thank you very much,
Do you need to operate at the database level after data backup and recovery?
Do the restored database and tryton associations need to execute any commands?
Thank you again for!

Not if you restore on the same version of Tryton that was used to make the backup. Otherwise you need to run an update like for any version migration.

I see. Thank you very much!

This topic was automatically closed 12 hours after the last reply. New replies are no longer allowed.