Postgres 13 was released yesterday
Does anyone know if Nextcloud 19 is compatible with PostgreSQL 13?
Postgres 13 was released yesterday
Does anyone know if Nextcloud 19 is compatible with PostgreSQL 13?
They donât do this later, the highest version is currently 11:
https://docs.nextcloud.com/server/19/admin_manual/installation/system_requirements.html
For NC 20 there are the last testing versions out before the final release early October. You could test this and check if they can put it as officially supportedâŚ
I donât know why there is no support for more recent versions if there were important changes or just nobody tested it. Keep an eye on the bug-tracker https://github.com/nextcloud/server/issues
Thanks for your reply.
I doubt that the highest supported version is Postgres 11. I think the docs are outdated. Nextcloudâs Docker examples currently donât even specify a specific Postgres version so many people have been using Nextcloud with Postgres 12 (without problems AFAIK). If you create a new Nextcloud installation right now using Nextcloudâs own Docker examples you would automatically be using Postgres 13.
I donât expect there to be breaking changes when upgrading from Postgres 12 to 13. But Iâd like to be sure of that before upgrading my own installation so if anyone did the upgrade, let us know if it works
I can confirm that running Postgres 12 in a Docker environment works fine. I have not yet tested Postgres 13.
Please test and update the docs for NC 20 (and perhaps earlier).
I gave it a shot with Nextcloud 20 in my environment and so far there are no errorsâŚ
I have migrated postgre 12 to 13 successfully and running with NC 19.0.4 (stable)
No problems for now. PostgreSQL 13 has a little less RAM consumption i feel in compare to 12.
Looks nice - worth a try
If you are concerning performance issues with postgresql 13 after migrating it might be helpful to set the following variable
log in to your postgresql
sudo -u postgres psql
in the psql# prompt enter
ALTER SYSTEM SET jit=âoffâ;
This will enter the setting to
/var/lib/postgresql/13/main/postgresql.auto.conf
quit the postgres session by âquitâ and reboot the server.
This setting helped for the matrix-synapse installation to boost up the db performance and i set this value to my nextcloud too.
If you want to reset those settings to default log in to your PostgreSQL again and type
ALTER SYSTEM RESET configuration_parameter
or in case of only the one parameter above you also could use
ALTER SYSTEM RESET ALL
Further performance settings can be calculated here:
and after that you enter the performance tips in the /etc/postgresql/13/main/postgresql.conf
(remark that the calculator above still ends at postgre12 so be patient and await the update till it is possible to choose 13)
Update 31.10.2020
PG Tune has updated itâs tools for Postgre 13
Iâve created a PR for the docs to be updated: