PostgreSQL 18 released -> in nextcloud >=31.0.9 supported yet?

ℹ️ Support
, ,
1
Support intro

Sorry to hear you’re facing problems. :slightly_frowning_face:

The community help forum (help.nextcloud.com) is for home and non-enterprise users. Support is provided by other community members on a best effort / “as available” basis. All of those responding are volunteering their time to help you.

If you’re using Nextcloud in a business/critical setting, paid and SLA-based support services can be accessed via portal.nextcloud.com where Nextcloud engineers can help ensure your business keeps running smoothly.

Getting help

In order to help you as efficiently (and quickly!) as possible, please fill in as much of the below requested information as you can.

Before clicking submit: Please check if your query is already addressed via the following resources:

(Utilizing these existing resources is typically faster. It also helps reduce the load on our generous volunteers while elevating the signal to noise ratio of the forums otherwise arising from the same queries being posted repeatedly).

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can. :heart:

The Basics

  • Nextcloud Server version (e.g., 29.x.x):
    • 31.0.9
  • Operating system and version (e.g., Ubuntu 24.04):
    • 24.04.3
  • Web server and version (e.g, Apache 2.4.25):
    • NGinx1.28
  • Reverse proxy and version _(e.g. nginx 1.27.2)
    • NGinx 1.24
  • PHP version (e.g, 8.3):
    • 8.3.11
  • Is this the first time you’ve seen this error? (Yes / No):
    • n/a
  • When did this problem seem to first start?
    • n/a
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
    • VM on Proxmox
  • Are you using CloudfIare, mod_security, or similar? (Yes / No)
    • No

Summary of the issue you are facing:

There is no issue, but the question is, if nextcloud 31.0.9 or one of its settings / php files will check an used PostgreSQL 18 as unsupported yet?

Steps to replicate it (hint: details matter!):

  1. PostgreSQL 18 is released

  2. Will nextcloud warn, if a higher PGSQL version than 17 is in use?

  3. here we had already a problem with PostgreSQL 17 for several weeks until an update has been released: Is anyone on the way with NC29 / 30 combined with latest stable PostgreSQL 17? - #6 by besimux

  4. there have been performance changes in PSQL 18 etc.
    PostgreSQL: PostgreSQL 18 Released!

2

Yes, it will: server/apps/settings/lib/SetupChecks/SupportedDatabase.php at 407cc430694978e173f578e40c30ff545012b532 · nextcloud/server · GitHub

This will only change if all components support Postgres 18 and we also test against that version. It might still be working fine, but the message will only change when everything is aligned

3

Thanks! So it is recommended to not migrate 17 → 18 until nextcloud “SupportedDatabase.php” is ready … (in productive environment)

4

Strange. I do use since some days PostgreSQL 18 on my Debian 12 Server for my NC 31.0.9. No Warnings at all and also no problems

root@DebianServerVM2:~# psql -V
psql (PostgreSQL) 18.0 (Debian 18.0-1.pgdg12+3)
root@DebianServerVM2:~#
5

Please post what is displayed under Database under Administration settings->System.

6

There were several month of development and testing and i think it’s a good idea to ask how processed is the implementation of postgresql 18 in nextcloud?

In 32.0.3 there is still no (official) support for psql 18 but maybe we have new perceptions for using it or migrating 17 → 18.

Thanks in advance!

7

Hi, postgres 18 support has been added to Nextcloud 33: https://github.com/nextcloud/server/pull/56155

8

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