For the deployment of Retool in the service type JOBS_RUNNER
I use the environment variable DATABASE_URL
to specify the connection to the database.
The connection string is exemplarily as follows: postgres://my-user:my-password@my-host:5432/my-database?currentSchema=foobar
The instance boots without problems. In the logs I don't find any errors and I even see that the migration was executed successfully "Database migrations are up to date".
Only when I connect to the database with a SQL client, there are no tables in the said schema and also the MAIN_BACKEND
says at startup that migrations are pending.
As soon as I remove "currentSchema" from the connection string, everything works.
To me it seems like maybe something is missing in the configuration or that the currentSchema
parameter is not supported at all.