Hi @solidstatesociety, thanks for your help!
I’ve created 2 files:
/config/env/production/database.js
/config/env/production/server.js
And pasted your code, I’ve also updated my .env file to match the values from the environment variables automatically set up in Railway. However, when I deploy it still doesn’t seem to do anything with the Postgres database on Railway. I also noticed that on Railway the environment variable keys are different to Strapi, eg. on Railway it’s PGUSER not DATABASE_USERNAME. However I tried both the keys you used and the keys on Railway and neither worked anyway.
Any ideas? Thanks again