We are using Openfire 3.6.3 with PostgreSQL as external database. For our service we periodically backup the database.
To ensure clean backups, we need to ensure that the data recorded in the database are in coherency, if possible without stopping the Openfire server.
So the question is: are Openfire and its plugins implementing SQL transactions and commit when writing to multiple tables data?
Thanks for your answer.