Heroku: installing Postgres without local db | Django

Question

I've already pushed my Django files to Heroku via Git and now I'd like to configure at Heroku server the Postgres database. After that, I need to transfer my local sqlite database to Heroku Postgres.

All of this issue is because I don't have admin rights on my local PC (corporate unit) to install Postgres.

So basically:

1. Configure remotely Postegres at Heroku;
2. Migrate local database (sqlite) to Heroku (Postgres).

I don't know if there is another path to go on...

Thank you!

Nitin Nain · Accepted Answer · 2020-05-23 17:58:32Z

1

That's some crazy gymnastics you're trying to do. Getting a grasp of PostgreSQL setup is hard as it is. There are several user/table privileges you have to maintain. Sqlite3 has very simple settings in the settings.py file in Django, while Postgres requires a username, password, Host, and Port.

Also the sql you export from sqlite3, might not ingest directly into the PostgreSQL. See this. You'll have to install Postgres on your local machine, if you plan to have any sort of ok workflow as far as I can see. You can probably explore docker to create a local dev environment on your corporate PC.

answered May 23, 2020 at 17:58

Nitin Nain

5,5231 gold badge40 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Felipe Dourado Over a year ago

Fortunatelly, I got installed a previous PostegreSQL (10.X) via binary code. Thank you for your reply.

Collectives™ on Stack Overflow

Heroku: installing Postgres without local db | Django

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related