aligredo
Postgresql On Heroku
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
Marked As Solved
outlog
heroku run "POOL_SIZE=2 mix ecto.migrate"
see Deploying on Heroku — Phoenix v1.8.8
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) Postico 2 - or similar for your platform..
you could also dump your local DB and restore the heroku DB to that dump Importing and Exporting Heroku Postgres Databases | Heroku Dev Center
Popular in Questions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Deploy Phoenix to your own VPS with PaaS ease: push-to-deploy, zero downtime, auto SSL, managed Postgres. 14-day free trial at potions.io
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #hex
- #security
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking for Elixir devs who love to ship. Start your free account.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"