Package: rtc.debian.org Severity: wishlist Prosody data (roster/buddy-list) is currently stored in files under /var/lib/prosody
DSA would potentially support a PostgreSQL database Prosody has a module for PostgreSQL storage: http://prosody.im/doc/modules/mod_storage_sql What benefits would we gain from this? Is it more resilient, faster or easier to support clustering? It may be useful for reporting too (e.g. reporting on the number of active users, average number of roster entries) What are the risks and maintenance overheads, if any? What is the strategy for migrating the data? It looks like there is a tool: http://prosody.im/doc/migrator