Dec 13 16:08:54 erebion.eu prosody[1455809]: sql: Error in SQL transaction: /usr/lib/prosody/util/sql.lua:150: Error preparing statement handle: ERROR: relation "prosody" does not exist
LINE 2: FROM "prosody"'
Trying to get a Prosody XMPP server working, but no idea what this means.
If there's something that does not exist in the database, I'd expect Prosody to ensure it exist... right?
Prosody IM
in reply to erebion • • •Yes, Prosody will automatically create the tables it needs if you provide the database and grant it the necessary permissions.
However, do consider whether you need postgres, or whether the default storage or sqlite will suffice. Postgres (as great as it is) generally adds unnecessary complexity to your deployment unless you have a specific reason to use it.
Finally, do check out our community chat if you have questions or problems 🙂
prosody.im/discuss
Community and discussion channels – Prosody IM
prosody.im