katafrakt
I have really weird issue with Ecto connecting to Supabase. Perhaps someone faced something similar.
I recently deployed an app to fly.io with database on Supabase. The app deployed, the migrations were run, I can see the tables in Supabase UI.
However, now I wanted to seed the database from my local machine. I have a separate repo with seeds. I put the connection config (same as a deployed app) onto it, but when I try to run the seeds I see an error that a relation cannot be found. At the same time I can see that a table with that name exists in Supabase UI. I can connect using the same config via psql = I see the tables. Only when connecting via Ecto the tables cannot be seen.
I tried querying for search path - looks ok. I tried executing raw SQL with table name prefixed by a schema - table not found. I can query pg_catalog and information_schema - all show no tables (except built-in ones) when queried via Ecto.
Any ideas what might be wrong here? The libraries like Ecto and Postgrex are in most recent versions, if that matters. Elixir i 1.18.2 on OTP27.
Update: Tried also with different version of Elixir (1.16) and OTP (26), but still the same result.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Elixir, Erlang & messaging conferences from Code Sync. Next up: ElixirConf US (10–11 Sep) & Code BEAM Europe (21–22 Oct), Haarlem + online.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #elixirconf-us
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #security
- #elixirconf-eu
- #api
- #forms
- #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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
Producing high quality Elixir screencasts since 2017.
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!"
Showing Posts 1 to 1- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
katafrakt
Ok, nevermind, I tried session pooler instead of direct connection and it worked now.