[Bug]: NC 25 RC5 not compatible with postgresql 15

[SimplyCorbett]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• Nextcloud Server is running on 64bit capable CPU, PHP and OS.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

Postgresql 15 was released today and nextcloud 25 RC5 and it is not happy with postgresql 15. Any ETA on a fix?

Steps to reproduce

Install PHP 8.1-fpm and postgresql 15 and try installing NC 25 RC5 on debian 11.

Install using source https://download.nextcloud.com/server/prereleases/nextcloud-25.0.0rc5.zip

Expected behavior

Works as expected

Installation method

No response

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.1

Web server

Nginx

Database engine version

PostgreSQL

Is this bug present after an update or on a fresh install?

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

No response

List of activated Apps

All standard apps on install

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

[szaimen]

Did you get some error logs with that or what doesnt work?

[SimplyCorbett]

It doesn't install. There are no errors listed in the nextcloud.log but this is output on the website:

[SimplyCorbett]

Likely related to this:

https://www.postgresql.org/docs/release/15.0/

Remove PUBLIC creation permission on the [public schema](https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PUBLIC) (Noah Misch)

[szaimen]

An easy workaround would be creating the user and database manually beforehand:

https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/linux_database_configuration.html#:~:text=then%20a%20postgres%3D%23%20prompt%20will%20appear.%20now%20enter%20the%20following%20lines%20and%20confirm%20them%20with%20the%20enter%20key%3A

[jotoeri]

It doesn't install. There are no errors listed in the nextcloud.log but this is output on the website:

Same error on App CI now.
https://github.com/nextcloud/forms/actions/runs/3254396564/jobs/5343637661#step:7:71
https://github.com/nextcloud/contacts/actions/runs/3253872431/jobs/5341551723#step:7:69

[SimplyCorbett]

An easy workaround would be creating the user and database manually beforehand:

That doesn't work either.

postgres=# CREATE DATABASE nextcloud TEMPLATE template0 ENCODING 'UNICODE';
ERROR:  encoding "UTF8" does not match locale "en_US"
DETAIL:  The chosen LC_CTYPE setting requires encoding "LATIN1".

[szaimen]

Does the following work?

CREATE DATABASE nextcloud_db TEMPLATE template0 ENCODING 'UTF8';
CREATE USER nextcloud_user WITH PASSWORD 'nextcloud_user_password' CREATEDB;
ALTER DATABASE nextcloud_db OWNER TO nextcloud_user ;

[SimplyCorbett]

Does the following work?

CREATE DATABASE nextcloud_db TEMPLATE template0 ENCODING 'UTF8';
CREATE USER nextcloud_user WITH PASSWORD 'nextcloud_user_password' CREATEDB;
ALTER DATABASE nextcloud_db OWNER TO nextcloud_user ;

No.

postgres=# CREATE DATABASE nextcloud_db TEMPLATE template0 ENCODING 'UTF8';
ERROR:  encoding "UTF8" does not match locale "en_US"
DETAIL:  The chosen LC_CTYPE setting requires encoding "LATIN1".

[szaimen]

postgres=# CREATE DATABASE nextcloud_db TEMPLATE template0 ENCODING 'UTF8';
ERROR: encoding "UTF8" does not match locale "en_US"
DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1".

found this: https://stackoverflow.com/a/33030572