# Postgres

**URL:** <https://discourse.joplinapp.org/t/postgres/37747>\
**Category:** Support\
**Created:** [22 April 2024 15:06 UTC](https://discourse.joplinapp.org/t/postgres/37747 "2024-04-22T15:06:47Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![poudenes](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/poudenes/32/9622_2.png) [@poudenes](https://discourse.joplinapp.org/u/poudenes)\
**Post date:** [22 April 2024 15:06 UTC](https://discourse.joplinapp.org/t/postgres/37747/1 "2024-04-22T15:06:47Z")

</div>

### 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?

---

<div class="post-metadata">

**Author:** ![dpoulton](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/dpoulton/32/29723_2.png) [@dpoulton](https://discourse.joplinapp.org/u/dpoulton)\
**Post date:** [22 April 2024 18:47 UTC](https://discourse.joplinapp.org/t/postgres/37747/2 "2024-04-22T18:47:03Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![dpoulton](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/dpoulton/32/29723_2.png) [@dpoulton](https://discourse.joplinapp.org/u/dpoulton)\
**Post date:** [22 April 2024 22:37 UTC](https://discourse.joplinapp.org/t/postgres/37747/3 "2024-04-22T22:37:08Z")

</div>

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](https://discourse.joplinapp.org/t/issue-upgrading-joplin-server-on-docker/34912).

---

<div class="post-metadata">

**Author:** ![l-ucky](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/l-ucky/32/6493_2.png) [@l-ucky](https://discourse.joplinapp.org/u/l-ucky)\
**Post date:** [23 April 2024 01:50 UTC](https://discourse.joplinapp.org/t/postgres/37747/4 "2024-04-23T01:50:58Z")

</div>

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 admins (me) to do major (15 -\> 16) upgrades. I hate migrating, so much.

I have PGSQL 15 in my docker-compose.yml.

---

<div class="post-metadata">

**Author:** ![banan314](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/banan314/32/5012_2.png) [@banan314](https://discourse.joplinapp.org/u/banan314)\
**Post date:** [2 May 2024 12:39 UTC](https://discourse.joplinapp.org/t/postgres/37747/5 "2024-05-02T12:39:17Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![isdnfan](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/isdnfan/32/15418_2.png) [@isdnfan](https://discourse.joplinapp.org/u/isdnfan)\
**Post date:** [17 May 2024 19:52 UTC](https://discourse.joplinapp.org/t/postgres/37747/6 "2024-05-17T19:52:18Z")

</div>

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](https://discourse.joplinapp.org/t/experience-and-upgrade-hints-for-server-upgrade-to-2-14-2-beta/36743)

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex028/uploads/cozic/original/3X/1/c/1c948e33314e232a0927789508474d8624f4270b.png) [@system](https://discourse.joplinapp.org/u/system)\
**Post date:** [16 June 2024 19:52 UTC](https://discourse.joplinapp.org/t/postgres/37747/7 "2024-06-16T19:52:36Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.