Unable to chose POSTGRES_USERNAME and POSTGRES_DB with manual installation

[arthurpers86]

I am deploying Nextcloud using the manual-install and configuring it to use my own PostgreSQL database hosted on a separate VM.

I have created a database user in PostgreSQL and set the corresponding environment variable POSTGRES_USER with this username. However, this setup does not work as expected because the prefix "oc_" is added to the username here and here.

I also see that POSTGRES_USER and POSTGRES_DB is hardcoded here.

What is the purpose of adding this prefix?
Why are environment variables for POSTGRES_USER and POSTGRES_DB defined if their values cannot be changed?

[szaimen]

Hi, this has technical and legacy reasons. I guess this should be documented though. Can you create a PR?

[arthurpers86]

Hi, thanks for your answer. Do you expect only documentation for this issue?
Is it not possible to have a better separation between manual-installation and mastercontainer installation ?

[szaimen]

Do you expect only documentation for this issue?

Yes, this would be great.

Is it not possible to have a better separation between manual-installation and mastercontainer installation ?

I fear this is indeed not possible because the same containers are used in both installation methods

[arthurpers86]

I rebuilt the nextcloud/aio-nextcloud and nextcloud/aio-notify-push images after removing those lines, and it works fine.

Would it not be possible to define these variables with the required prefix directly here ? I assume this would only affect mastercontainer.
And set it as default in the manual-install conf for the ones using nextcloud/aio-postgresql ?

[szaimen]

No, this is not possible because it breaks existing instances