Operating system Linux Joplin version 2.14.20 Desktop version info na Sync target Joplin Server Editor Rich Text Editor What issue do you have? What is latest postgres version supported?

I don't know what the very latest version of Postgres is but my Joplin server has been running for a while now on 16.1 which I believe is reasonably current. EDIT: Just for the heck of I just upgraded my Joplin Server db to Postgres 16.2 (current stable). Nothing bad has happened!

Just to be clear in case you are already running a Joplin Server. I have never had an issue with a Postgres point release upgrade. Version upgrades are a different matter, that takes work .

I have PGSQL as the database version for Joplin-Server. I'm not updating unless Joplin, for some reason, requires a 16+ upgrade. I don't think there's a huge pain-in-the-ass upgrade you have to do for total server upgrades. However, I know that Matrix-Synapse, for example, will eventually require a…

Is postgres faster than sqlite when you have 4000+ notes? I googled it and it said in general postgres is slower because it's a managed relational database and manging all those objects adds an overhead but what is the practice?

Postgres

Support

isdnfan 17 May 2024 19:52 6

In fact Joplin 2.14.2 server requires PGSQL 16 - look at my experience Experience and upgrade hints for Server upgrade to 2.14.2-beta

Topic		Replies	Views
Issue upgrading Joplin Server on Docker Support	4	1146	5 January 2024
Do not upgrade to Postgres 14, which is incompatible with Joplin server Lounge	0	628	1 October 2021
Database error Development	5	4055	10 November 2022
Migrate from sqlite to PostgreSQL Support	17	1803	15 September 2023
How to upgrade Joplin Server (and not loose data)? Support	0	183	12 February 2026

Postgres

Related topics