Database Management » History » Version 2
Version 1 (digitalcircuit, 06/17/2018 08:09 PM) → Version 2/3 (digitalcircuit, 06/17/2018 08:51 PM)
h1. Database Management
Most tasks involving the can be accomplished within Quassel itself, and when possible, you should use those options (_e.g. deleting chat by right-clicking buffers, Delete Chats_). However, some actions, such as deleting Quassel users, deleting backlog older than a certain date, and cleanup require manually modifying the database while the Quassel core is stopped.
The steps to take depend on which database backend you're using. If you don't know, it's most likely *SQLite*.
*See See the pages for...* for...
* [[SQLite]]
* [[PostgreSQL]]
h2. Migrating SQLite to PostgreSQL
In many cases, PostgreSQL offers better performance and greater reliability than SQLite.
To migrate, see the setup and migration documentation on [[PostgreSQL]].
Most tasks involving the can be accomplished within Quassel itself, and when possible, you should use those options (_e.g. deleting chat by right-clicking buffers, Delete Chats_). However, some actions, such as deleting Quassel users, deleting backlog older than a certain date, and cleanup require manually modifying the database while the Quassel core is stopped.
The steps to take depend on which database backend you're using. If you don't know, it's most likely *SQLite*.
*See See the pages for...* for...
* [[SQLite]]
* [[PostgreSQL]]
h2. Migrating SQLite to PostgreSQL
In many cases, PostgreSQL offers better performance and greater reliability than SQLite.
To migrate, see the setup and migration documentation on [[PostgreSQL]].