production:
primary: &primary_production
<<: *default
database: app_production
username: app
password: <%= ENV["APP_DATABASE_PASSWORD"] %>
//IN CASE I HAVE A URL
cache:
<<: *primary_production
database: app_production_cache
migrations_paths: db/cache_migrate
queue:
<<: *primary_production
database: app_production_queue
migrations_paths: db/queue_migrate
cable:
<<: *primary_production
database: app_production_cable
migrations_paths: db/cable_migrate
I dont really get how this work. If i work with railway.com with postgresql, this means i need to have 4 different databases?
I have gotten two different errors: relation “solid_queue_jobs” does not exist, and relation “solid_cache_jobs” does not exist – so i ended up creating a migration for each of the queue_schema, cache_schema. I dont understand how am i supposed to work with migrations using these. Are they supposed to migrate on their own if a database exists for them? If i have them specified like you see on the code, why do they still migrate but can’t find the database?
I dont really get how this work. If i work with railway.com with postgresql, this means i need to have 4 different databases?
I’m not familiar with railway.com, but yes you will have 4 different databases.
I have gotten two different errors: relation “solid_queue_jobs” does not exist, and relation “solid_cache_jobs” does not exist – so i ended up creating a migration for each of the queue_schema, cache_schema. I dont understand how am i supposed to work with migrations using these. Are they supposed to migrate on their own if a database exists for them? If i have them specified like you see on the code, why do they still migrate but can’t find the database?
I am using rails 8 so all of them come already installed. The issues i am facing is with the migrations of each. This is why i keep getting:
relation “solid_queue_jobs” does not exist, and relation “solid_cache_jobs” does not exist.
My queue_schema, and cache schema are there in my db folder, but no migrations are generated.
(From what I can see of the file you submitted in your original post, it looks like you’re in production, but it’s always good to ask the question in case.)
Because for instance according to the documentation of solid_queue, if you’re in production, for example, you need to run the command: rails db:prepare, to ensure the db is created and the schema is loaded.
Then run db:prepare in production to ensure the database is created and the schema is loaded.