Skip to content

Instantly share code, notes, and snippets.

@bradtraversy
Created August 16, 2019 16:38
Show Gist options
  • Star 57 You must be signed in to star a gist
  • Fork 51 You must be signed in to fork a gist
  • Save bradtraversy/0029d655269c8a972df726ed0ac56b88 to your computer and use it in GitHub Desktop.
Save bradtraversy/0029d655269c8a972df726ed0ac56b88 to your computer and use it in GitHub Desktop.
Python & Postgres Heroku Deployment

Python Heroku Deployment

Steps to create a postgres database and deply a Python app to Heroku

Install guinicorn locally

pipenv install gunicorn
or
pip install gunicorn

Install Heroku CLI

https://devcenter.heroku.com/articles/heroku-cli

Login via CLI

heroku login

Create app

heroku create appname

Create database

heroku addons:create heroku-postgresql:hobby-dev --app appname

Get URI

heroku config --app appname

# Add to your app

Create Procfile

touch Procfile

# Add this
web: gunicorn app:app

Create requirements.txt

pip freeze > requirements.txt

Create runtime.txt

touch runtime.txt

# Add this
python-3.7.2

Deploy with Git

git init
git add . && git commit -m 'Deploy'
heroku git:remote -a appname
git push heroku master

Add table to remote database

heroku run python
>>> from app import db
>>> db.create_all()
>>>exit()

Visit app

heroku open
@esha123802
Copy link

image
im at this part already, im having this problem, i appreciate any sort of help I can get.

Im having the same error, did you figure it out? I have added the bin path to env also

@srinumadhavv
Copy link

Everything is running fine but unable to access the database , it says table not found

@lena-A-Al
Copy link

heroku open
is not working?

@Olney1
Copy link

Olney1 commented Sep 2, 2022

Hey Brad, could you add the CLI commands for viewing the database tables?

@Yemsquare
Copy link

Hey, having issue with creating the table with PostgreSQL

@kelderanyi
Copy link

heroku open is not working?

use this instead "heroku open --app appname

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment