rambler icon indicating copy to clipboard operation
rambler copied to clipboard

No schema selected?

Open ryanpcmcquen opened this issue 4 years ago • 1 comments

I have a bevy of migrations that are failing to run, due to the following error:

info  initializing database
unable to initialize database: pq: no schema has been selected to create in

RAMBLER_SCHEMA is set to a schema that gets created inside of the migrations.

Unfortunately, the project is closed source or else I would share a link here, but is there a way to log additional debug?

Rambler version: 5.3.0

ryanpcmcquen avatar Nov 14 '21 22:11 ryanpcmcquen

The issue is that rambler is trying to create a table at the initialization step to keep track of what migrations are applied, and can't do it because your schema doesn't exists yet. This is a chicken-egg issue that I don't have a clever solution for, as I don't use Postgres myself.

I'm open to suggestions tho, what would be correct behavior in this case given Postgres best-practices? Maybe we should force the migration table to be created in the public schema?

elwinar avatar Nov 16 '21 09:11 elwinar