Latest #postgrex Threads 
This deep-dive into Postgres’ Write-Ahead Log (WAL) covers how to track database changes without changing a single line of application code!
New
Besides (over)logging every code-path leading to Repo.insert_all, is it possible to make Postgrex and/or ecto_sql log the exact, failing ...
New
Hello :wave:
I’m using Ecto along with PostgreSQL. I’ve been trying to add a field containing a 2-tuple to an Ecto schema, but can’t see...
New
Hello, I am trying to do a postgrex query with the sql library where I get the first entry from a table sorted by last_visited and exclud...
New
I am trying to do pattern matching against a postgrex result, as such:
{:ok, %Postgrex.Result{rows: [[result]]}} = Postgrex.query!(:post...
New
Hello there.
I’m using ecto 3.10.3, ecto_sql 3.10.1 and postgrex0.17.2 on a rather simple service. For reason beyond my control my Postg...
New
Hi,
We have a regular Phoenix project using Ecto and Postgresql. But recently we are seeing a lot of connection timeouts or idle/closed ...
New
We were seeing bugs where 1) jobs would sit indefinitely in “available” and 2) the Oban Web dashboard would sometimes display a count of ...
New
Hello!
I am setting up a phoenix app and want to deploy it on Azure app service.
I run the docker image locally, and can connect to the...
New
Man. No idea what’s going on.
Somehow, a very stable postgrex config just seemed to stop working.
I isolated it to a new, empty project...
New
This Week's Trending
This Month's Trending
This Year's Trending
When running my tests, I sometimes see an error that looks like
[error] Postgrex.Protocol (#PID<0.788.0>) disconnected: ** (DBConn...
New
Hi, my colleagues and I at Supabase have worked on libcluster_postgres, a libcluster custom strategy that utilizes PostgreSQL LISTEN and ...
New
This deep-dive into Postgres’ Write-Ahead Log (WAL) covers how to track database changes without changing a single line of application code!
New
Besides (over)logging every code-path leading to Repo.insert_all, is it possible to make Postgrex and/or ecto_sql log the exact, failing ...
New
Last Three Year's Trending
Hi everyone, it seems I can’t get out of this forum this week :sweat_smile: (you guys are awesome btw).
So, I got surprised by this beha...
New
Hello everyone
I’m newcomer for here and mainly using elixir language. Currently I’m trying to connect my system (Elixir) with an Azure...
New
Postgrex doesn't send password? "(Postgrex.Error) FATAL 28000 (invalid_authorization_specification)"
Hello everyone!
I’m trying to deploy my blog application into production, and I’m facing a very weird issue: Postgrex doesn’t want to co...
New
I am trying to query a Postgres database that requires SSL connections from a Livebook session.
opts = [
hostname: "database.url.com",...
New
Are there any callbacks that I can hook into to reconnect, including redoing DNS resolution?
We’ve having some strange issues with Auror...
New
Is there a way to stream data TO the database with Ecto? I’m working on using the COPY command to load CSV data directly into Postgres.
...
New
I am trying to code a bank transfer service using Elixir/Erlang, Postgrex and PostgreSQL.
Erlang v 26
Elixir v 1.16.0
Postgrex v 0.17....
New
Folks,
I’m having a serious look into YugabyteDB (YB) and engaging with that team on several matters. In some respects YB is plug compat...
New
Just added some DSL magic :magic_wand: to WalEx. WalEx allows you to listen to change events on your Postgres tables then perform callbac...
New
Hello everyone, I hope you are well.
I’m migrating from PostgreSQL to CockroachDB and everything was going well until I came across the ...
New
This is not so much a question but rather an answer to an issue which took me some time to figure out, and maybe a suggestion to improve ...
New
Hello,
I am using mix release to run a Phoenix app in production. However, when I start the app as described in the mix release and Phoe...
New
Hello, I am trying to do a postgrex query with the sql library where I get the first entry from a table sorted by last_visited and exclud...
New
Greetings!
Elixir/Phoenix noob here, so it is possible this question may have been answered before, apologies :slight_smile:
I am tryin...
New
Hi,
We have a regular Phoenix project using Ecto and Postgresql. But recently we are seeing a lot of connection timeouts or idle/closed ...
New
Trending Over Three Years
Schema File:
defmodule Logistics.Users.User do
use Ecto.Schema
import Ecto.Changeset
@primary_key {:id, :binary_id, autogenerate:...
New
Background
We are making a proof of concept to use a postgres DB with Elixir. To achieve this we are using Postgrex.
Issue
The problem h...
New
My logs are showing intermittent timeout errors for queries that are normally really quick (milliseconds). They are just SELECT queries f...
New
I would like the resulting json from Postgrex query; to not be decoded by Jason.
Instead let it return as a binary / string and sent str...
New
What’s the best way to do bulk inserts with Postgrex?
If I have a list [[1,2],[3,4],[5,6]] what’s the ideal way to handle it in Postgrex.
New
I’m running into this error
** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "characters" does not exist
when I try to inser...
New
Hi Everyone, I’m trying to use PGPool in front of a PG database and Ecto’s using it but all commands failed. Here are the logs that I fig...
New
Since a few days ago I keep getting the following error on my dev machine when making requests to a phoenix app:
exited in: :gen_server....
New
As far as I’ve observed, I don’t notice any consistent pattern when this gets thrown. Seems the error gets thrown randomly. I tried searc...
New
I’m trying to delete a User in my system. Any given user has_many Project and Projects have_many Rows.
I’m running into an issue when tr...
New
Hi,
Looking at the documentation of the transaction/2 function it should return a {:ok, result} or {:error, reason} tuple. However, if I...
New
What could be the problem ?
[error] Postgrex.Protocol (#PID<0.3054.0>) disconnected: ** (Postgrex.Error) FATAL 57P01 (admin_shutdo...
New
When starting Elixir application, I get the “errors” screenshotted below. This is a basic Phoenix application that has been working fine ...
New
We need to store a lot of events in a PostgreSQL database.
We can be spikes sometimes, so the rate of inserts can overload the database ...
New
At this moment postgrex package have built-in point data type (geometric, not a PostGIS one), according to the source code:
I’m tr...
New
Latest on Elixir Forum
Get money off!
The Pragmatic Bookshelf
35% off any eBook
Manning Publications
45% off any item
ElixirCasts
10% off for life
The Pragmatic Studio
20% off any course
AppSignal
10% off for 12 months
Honeybadger
10% off for 12 months
Simply use coupon code "devtalk.com" or "elixirforum" at checkout!
Filter by Type:
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #exunit
- #elixirconf
- #discussion
- #javascript
- #podcasts
- #code-sync
- #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
- #distillery
- #api
- #processes
- #forms
- #metaprogramming
- #security
- #performance
- #hex
Forums
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.
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.
Courses that'll move you from confusion to "Aha, now I get it!"