lamporchestra
Hi everyone.
We are trying to use pgbouncer in front of a postgres. The pgbouncer is deployed as a flyio app,
and our elixir service is also deployed in fly io too.
We have also verified we can connect to the pgbouncer using psql and with running Postgrex.start_link/1 directly.
However, when using ecto, we are still receiving errors.
Example with Postgrex
iex(1)> Mix.install([:postgrex])
:ok
iex(2)> {:ok, pid} = Postgrex.start_link(hostname: "some-pg-bouncer-stg.fly.dev", port: 6432, username: "usernamehere", password: "passwordhere", database: "dbhere", socket_options: [:inet6])
{:ok, #PID<0.244.0>}
iex(3)> Postgrex.query!(pid, "SELECT id from tickets limit 1", [])
%Postgrex.Result{
command: :select,
columns: ["id"],
rows: [
[84058]
],
num_rows: 1,
connection_id: 1803789234,
messages: []
}
However, setting the same options in our config files
config :db, DB.Repo,
username: "usernamehere",
password: "passwordhere",
hostname: "some-pg-bouncer-stg.fly.dev",
database: "dbhere",
port: 6432,
socket_options: [:inet6],
causes our application to keep failing to connect with logs like
[error] Postgrex.Protocol (#PID<0.522.0>) failed to connect: ** (DBConnection.ConnectionError) tcp recv (idle): closed
Any ideas on what options to pass to the Ecto.Repo config or what other changes are needed to make this work?
Trending in Questions
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
Hello,
I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
Hi everyone,
I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding.
I sta...
New
Documentation
While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
New
So my question is quite simple and i have found no conclusive answer on forum, google or AI.
Should we use :erlang.float for Integer to ...
New
I recently noticed that Elixir’s Logger defaults its primary log level to :debug when no :logger, :level application configuration is pre...
New
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
Other Trending Topics
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
I am happy to introduce the very α version of the new programming language compiled to BEAM.
Welcome Cure.
It has literally three kille...
New
Hi there! We created Gust: A task orchestrator inspired by Airflow.
For those who have never heard about Aiflow, it’s a Python-based wor...
New
Hi everyone!
The first release candidate for the Expert language server project is now available!
We’ve published a press release detai...
New
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
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
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixirconf-us
- #ai
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #security











Showing Posts 1 to 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
josevalim
I am on my phone but there is a prepare: :unnamed option you can pass. I believe it is documented in Postgrex docs/README. Search for pgbouncer.
lamporchestra
Thanks!
Initially I got it to work without
prepare: :unnamed, but it turned out pgbouncer was set tosessionmode.Then I set
prepare: :unnamedin the Ecto.Repo config and switched totransactionmode in pgbouncer and everything just worked.