DEV Community

Django + PostgreSQL Deployment on Railway App

Meet Rajesh Gor on July 22, 2022

Introduction We have already seen the process of deployment of a Django app on Heroku, now we can move to another platform which is Rail...

Read full post

Osahenru • Sep 21 '22

Beautiful piece, thank you so much but I'm getting this error message "Application Error
is your app correctly listening on $PORT?"

I have done every thing I can from creating an environment variables in my railway project to deleting my project severally but still after a successful deployment my project still crashes.

Meet Rajesh Gor • Sep 21 '22

Have you entered the port number correctly from the postgres service on railway. I think that is probably the issue.

Osahenru • Sep 22 '22

Alright I'll try that out, although I didn't use postgresql for this project I used Django's default sql lite, I'll try this out and get back to you. thank you so much

Osahenru • Sep 23 '22

Fixed the issue. thanks for your assist

surya7765 • Dec 27 '22

Hey, May I know how you have fixed the issue?

uwuwuw • Jan 22 '23

@osahenru May I know how you fixed the issue?

Lucas Obwaku • Sep 22 '22

Add logging to your app then git and deploy. On your dashboard under deployment there is a view logs button.Then click build logs .This will tell you the exact problem.

Osahenru • Sep 23 '22

Thank you I'll try this out too

OlaNeat Ayoola • Sep 3 '22

halo, i followed this and i'm getting this error when i apply migration

Meet Rajesh Gor • Sep 4 '22

Thank you for reading and giving feedback,

Make sure you have created the PostgreSQL database service on Railway, specified the DATABASE_URL properly in the .env file, and setup dj-database-url for smooth working of the database operations.

Also you could try an alternative way instead of installing and setting up the dj-database-url:

Let's say my database url is given by railway as:

postgres://sjxgipufegmgsw:78cbb568e@ec2-52-4-104-184.compute-1.amazonaws.com:5432/dbmuget

This is of the format,

postgresql://user:password@hostname:port/db_name

So, we can convert this URL into a object like representation of the remote database in django settings.

DATABASES = {
    "default": {
        "ENGINE": "django.db.backends.postgresql",
        "NAME": "dbmuget",
        "USER": "sjxgipufegmgsw",
        "PASSWORD": "78cbb568e",
        "HOST": "ec2-52-4-104-184.compute-1.amazonaws.com",
        "PORT": 5432,
    }
}

Try these few things out and let me if it still doesn't works.

OlaNeat Ayoola • Sep 5 '22

tnks this worked but now i'm getting a different err

Meet Rajesh Gor • Sep 6 '22

The address of the hostname must be taken from the URL and don't use Localhost.

Waylon Walker • Jul 23 '22

very thorough post! I need to give railway a try

Meet Rajesh Gor • Jul 24 '22

Just curious. What kind of app will you deploy?

Waylon Walker • Jul 24 '22

No idea, I don't have anything that I need public compute for at the moment.

James Leonard • Sep 7 '22

please help me out with this error

Meet Rajesh Gor • Sep 7 '22

There might be problems in the psycopg2 package installation, so I have already mentioned in the post:

pip install psycopg2

# If it does not work try
pip uninstall psycopg2
pip install psycopg2-binary
pip freeze >requirements.txt


# if still error persists try installing setuptools
pip install -U setuptools
pip install psycopg2

If psycopg2 doesn't work, remove the packge from the requirements.txt file and add the psycopg2-binary package after installing.

Onyenzedon • Sep 23 '22

Hi Raj.. Please my own case is a bit different. I created different environments for the development and production. In development, I'm using sqlite3 database. In production, I'm using postgresql though through dj_database_url. Please, how do I createsuper user in production environment?

Lucas Obwaku • Sep 22 '22

After a successful deployment of a Django app to railways how do I add a superuser admin?

Meet Rajesh Gor • Sep 23 '22

Make sure your app is running on railway, and you can also add the railway database locally and run python manage.py createsuperuser. From this you can connect the railway db locally and create a superuser. From there on you can use admin from the deployed app.

Lucas Obwaku • Sep 23 '22

You should add how to deal with media files in production. This will make this blog complete

Dave Parr • May 31 '23

This helped me today, thanks for the updates.

giftedstan • Nov 4 '22

Hello, this is a beautiful write-up, i followed it and i have my app deployed, but i have one request, on heroku, we have an app called heroku scheduler, whats the alternative on railway?