Self-hosted Joplin Server stopped being accessible (no sync and public notes not available)

Support
3

I searched the forum for the error you are seeing and the only previous instance was one you reported.

Back then it was suggested that it may be a docker issue?

Anyway, I do not know if the database version could be the cause of your problem but this file on GitHub https://github.com/laurent22/joplin/blob/dev/packages/server/src/db.ts says that the minimum Postgres version is 12, so maybe it is not.

export const versionCheck = async (db: DbConnection) => {
	if (isPostgres(db)) {
		// We only support Postgres v12+
		// https://github.com/laurent22/joplin/issues/9695
		// https://www.postgresql.org/docs/current/rules-materializedviews.html
		const minPostgresVersion = '12.0';

In case you are not aware, if you do decide to try changing database versions it can require more than just updating your docker-compose file. This post helped me to migrate from Postgres v15 to v16:

1 Like