Owens
How to carry out a pg_dump on Gigalixir?
I’m trying to dump my production db on gigalixir so I can use the data for my frontend design and iteration in my local development environment.
The documentation doesn’t explain how to do this beyond getting the connection parameters.
Then I believe we have to import the result into psql manually?
When I used Heroku in the past you could just run a single line from the command line and it would all be done.
Appreciate any help!
Marked As Solved
Owens
Here’s how I solved this.
When you run gigalixir pg it gives you the “url” field. Simply type pg_dump in terminal and paste the URL, then --file=file_name_you_want
pg_dump postgresql://username:password@host/database --file=my_dump.sql
Once it downloads simply run
psql -d myapp_dev -f my_dump.sql
myapp_dev being the name of your db in the dev.exs file.
Not sure if it matters, but before I did this I ran mix ecto.drop and mix ecto.create to start with a fresh db.
Popular in Questions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Real-time error tracking, performance insights, and observability for devs.
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
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
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.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
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!"