Changes for page Backup/Restore

Last modified by Vincent Massol on 2024/12/17

From version 34.1

edited by Thomas Mortagne
on 2024/08/06

Change comment: There is no comment for this version

To version 34.2

edited by Nikita Petrenko
on 2024/10/25

Change comment: add details how to backup in postgresql

Summary

Page properties

Author

@@ -1,1 +1,1 @@
--XWiki.ThomasMortagne
++XWiki.nikitapetrenko

Content

@@ -22,7 +22,7 @@
  It's important that the backup is done with ##~-~-add-drop-database## since when you restore it it's important that tables that might have been created are removed. For example database migrations can create extra tables. If you want to cancel the migration and go back to your clean dump you'll need to have those tables removed as otherwise when you run the migration again later on you might have errors.
  {{/warning}}
  )))
--* **PostgreSQL**: You can use {{code language="shell"}}pg_dump xwiki > xwiki.sql{{/code}} to backup the PostgreSQL database. In case of backing up the whole instance, use the binary ##pg_dumpall## instead.
++* **PostgreSQL**: You can use {{code language="none"}}psql{{/code}} shell with the command {{code language="shell"}}pg_dump xwiki > xwiki.sql{{/code}} to backup the PostgreSQL database. In case of backing up the whole instance, use the binary ##pg_dumpall## instead. Alternatively to the shell, you can use the GUI application pgAdmin by selecting the database and from the context menu selecting Backup.
  * **Oracle**: Use ##exp## to export data.
  * **HSQLDB**: Simply backup the HSQLDB directory. For the XWiki standalone packaging it's the ##data/## directory.