GEONODE_DATABASE_SCHEMA isn't taken into account when creating the database

[lobenichou]

Expected Behavior

Expecting the schema to be the one defined in the env file and not 'public'

Actual Behavior

It remains unchanged

Steps to Reproduce the Problem

1. Assign a new schema with GEONODE_DATABASE_SCHEMA
2. build and start docker
3. check out the postgresql db structure

Specifications

• GeoNode version: 5
• Installation type (vanilla, geonode-project): geonode-project
• Installation method (manual, docker): docker
• Platform: Redhat 9
• Additional details:

I added the schema at the end of the database URL instead but it creates more issues down the line where some tables aren't correctly created.

[giohappy]

@lobenichou you raised a good point, also considering that usage of the PUBLIC schema should be avoided in recent PG versions.
We are analysing the effort to refactor the configuration of the schema, and I confirm that the GEONODE_DATABASE_SCHEMA variable is currently not taken into account.

We haven't scheduled the activity yet. If you can contribute please let us know.

[lobenichou]

@giohappy I could potentially take a look but I am not super familiar with the codebase.