Postgres support broken

[juliusknorr]

No description provided.

[zak39]

I have the same issue for me

[juliusknorr]

We need to figure out a way that we can dynamically create new databases named by the instance that is starting as it is done with mysql.

We may need to create a user with the relevant permissions or the individual databases manually through https://github.com/docker-library/docs/blob/master/postgres/README.md#initialization-scripts

[szaimen]

https://github.com/nextcloud/all-in-one/blob/main/Containers/postgresql/init-user-db.sh and https://github.com/nextcloud/all-in-one/blob/46f4136d30315d8538c6de29821bcd496ac0c1c5/Containers/postgresql/Dockerfile#L21 as reference

[juliusknorr]

Possibly related nextcloud/server#38750

[juliusknorr]

https://github.com/nextcloud/all-in-one/blob/main/Containers/postgresql/init-user-db.sh and https://github.com/nextcloud/all-in-one/blob/46f4136d30315d8538c6de29821bcd496ac0c1c5/Containers/postgresql/Dockerfile#L21 as reference

If possible I'd like to avoid to pressed databases as previously creating individual ones per stable container worked nicely.

[juliusknorr]

Turns out it was enough to just disable user creation using nextcloud/server#36428 and just use the superuser which is fine here since this is a insecure dev env anyways.