Postgresql On Heroku

Phoenix Forum Questions / Help
, , ,
1

Hello,

I deployed a simple api-only app on heroku, and it has postgresql but when I queried the data I had an error. This makes sense as the database is currently empty. My question is, has the migrations been applied on the database and does it have the same tables as the local dev database? If so how could I insert some data in it.

Thanks in advance

2

heroku run "POOL_SIZE=2 mix ecto.migrate"

see https://hexdocs.pm/phoenix/heroku.html#deploy-time

the DB will be empty - you should have some UI/backend to insert data… or some kind of seed task if needed…

if not you can use something like Postico (mac) https://eggerapps.at/postico/ - or similar for your platform…

you could also dump your local DB and restore the heroku DB to that dump https://devcenter.heroku.com/articles/heroku-postgres-import-export#import

2 Likes