# \#postgres

**URL:** https://forum.elixirforum.com/tag/postgres/285.md

[Latest](https://forum.elixirforum.com/latest.md) · [Categories](https://forum.elixirforum.com/categories.md) · [Tags](https://forum.elixirforum.com/tags.md)

---

## [Oliver Banoub - Cairo, Egypt (Remote) – Elixir/Ash backend dev contract](https://forum.elixirforum.com/t/oliver-banoub-cairo-egypt-remote-elixir-ash-backend-dev-contract/77399)

<div class="topic-metadata">

**Author:** [@OliverFady](https://forum.elixirforum.com/u/OliverFady)\
**Replies:** 0\
**Last updated:** [November 16, 2026, 2:05am UTC](https://forum.elixirforum.com/t/oliver-banoub-cairo-egypt-remote-elixir-ash-backend-dev-contract/77399 "2026-11-16T02:05:34Z")

</div>

Name: Oliver Banoub Location: Cairo, Egypt (UTC+2) Remote / relocate: Remote only; can cover 10:00–17:00 US Eastern Looking for: Part-time or contract work I’m a backend engineer (~3 yrs in production) working mostly…

---

## [The GenServer is a cache, Postgres is the queue - why my agent queue survives deploys](https://forum.elixirforum.com/t/the-genserver-is-a-cache-postgres-is-the-queue-why-my-agent-queue-survives-deploys/77343)

<div class="topic-metadata">

**Author:** [@T0ha666](https://forum.elixirforum.com/u/T0ha666)\
**Replies:** 0\
**Last updated:** [November 10, 2026, 10:11am UTC](https://forum.elixirforum.com/t/the-genserver-is-a-cache-postgres-is-the-queue-why-my-agent-queue-survives-deploys/77343 "2026-11-10T10:11:39Z")

</div>

I run a kanban of AI coding agents, and one afternoon the board showed three tasks running while the profile page on the same screen said two running and one queued. Both were correct: one card was waiting in line, and n…

---

## [ AuditTrailEx - transaction-safe audit logging for Ecto (with optional Postgres triggers)](https://forum.elixirforum.com/t/audittrailex-transaction-safe-audit-logging-for-ecto-with-optional-postgres-triggers/76952)

<div class="topic-metadata">

**Author:** [@HataluliRandima](https://forum.elixirforum.com/u/HataluliRandima)\
**Replies:** 5\
**Last updated:** [October 25, 2026, 12:43pm UTC](https://forum.elixirforum.com/t/audittrailex-transaction-safe-audit-logging-for-ecto-with-optional-postgres-triggers/76952 "2026-10-25T12:43:59Z")

</div>

Hi everyone I have just published AuditTrailEx 0.1.0, an audit logging and change-history library for Ecto. I built it for my own Phoenix app and would love feedback before I go further. What it does It wraps your Repo …

---

## [Michal Kwiatkowski, Poland - Senior Software Engineer with 20+ years of experience](https://forum.elixirforum.com/t/michal-kwiatkowski-poland-senior-software-engineer-with-20-years-of-experience/77115)

<div class="topic-metadata">

**Author:** [@michalk](https://forum.elixirforum.com/u/michalk)\
**Replies:** 0\
**Last updated:** [October 21, 2026, 3:19pm UTC](https://forum.elixirforum.com/t/michal-kwiatkowski-poland-senior-software-engineer-with-20-years-of-experience/77115 "2026-10-21T15:19:11Z")

</div>

Name: Michal Kwiatkowski Location: Gdansk, Poland I have over 20 years of experience developing successful web applications. I can contribute across the entire project lifecycle, from gathering and refining requirement…

---

## [Postgrex starts failing to connect over SSL with :hostname\_check\_failed after OS update (Fedora 42 to 43)](https://forum.elixirforum.com/t/postgrex-starts-failing-to-connect-over-ssl-with-hostname-check-failed-after-os-update-fedora-42-to-43/76656)

<div class="topic-metadata">

**Author:** [@andrewf](https://forum.elixirforum.com/u/andrewf)\
**Replies:** 2\
**Last updated:** [September 15, 2026, 6:41am UTC](https://forum.elixirforum.com/t/postgrex-starts-failing-to-connect-over-ssl-with-hostname-check-failed-after-os-update-fedora-42-to-43/76656 "2026-09-15T06:41:55Z")

</div>

I’m using Postgrex in a Phoenix app to connect to Postgres. The database for my dev instance is in a local VM, with hostname jot.local. My app is set up so that any database connection to a different machine runs over SS…

---

## [Rodrigo Álvarez, Spain - Senior Software Engineer, \>20 years of experience](https://forum.elixirforum.com/t/rodrigo-alvarez-spain-senior-software-engineer-20-years-of-experience/76480)

<div class="topic-metadata">

**Author:** [@Papipo](https://forum.elixirforum.com/u/Papipo)\
**Replies:** 0\
**Last updated:** [August 27, 2026, 11:15am UTC](https://forum.elixirforum.com/t/rodrigo-alvarez-spain-senior-software-engineer-20-years-of-experience/76480 "2026-08-27T11:15:28Z")

</div>

Name: Rodrigo Álvarez Location: Gijón, Spain Available for full remote backend/fullstack work. Experience: More than 20 years, 20 of them as remote ruby/rails developer. A couple of years ago I switched to the beam (E…

---

## [Federico Meini - Italy (remote), 10+ yrs: Elixir & Postgres at scale in production, WhatsApp Business, AI agents - available for new projects](https://forum.elixirforum.com/t/federico-meini-italy-remote-10-yrs-elixir-postgres-at-scale-in-production-whatsapp-business-ai-agents-available-for-new-projects/76477)

<div class="topic-metadata">

**Author:** [@fedme](https://forum.elixirforum.com/u/fedme)\
**Replies:** 0\
**Last updated:** [August 27, 2026, 9:44am UTC](https://forum.elixirforum.com/t/federico-meini-italy-remote-10-yrs-elixir-postgres-at-scale-in-production-whatsapp-business-ai-agents-available-for-new-projects/76477 "2026-08-27T09:44:55Z")

</div>

Name: Federico Meini Location: Italy (UTC+1/+2) Remote / relocation / travel: Remote only Work experience: Backend engineer with more than 10 years of experience, the last 6 in production Elixir at Turn.io, a WhatsApp…

---

## [Torus - Integrate PostgreSQL's search into Ecto queries](https://forum.elixirforum.com/t/torus-integrate-postgresqls-search-into-ecto-queries/70024)

<div class="topic-metadata">

**Author:** [@dimamik](https://forum.elixirforum.com/u/dimamik)\
**Replies:** 23\
**Last updated:** [August 24, 2026, 9:56am UTC](https://forum.elixirforum.com/t/torus-integrate-postgresqls-search-into-ecto-queries/70024 "2026-08-24T09:56:45Z")

</div>

Torus is a plug-and-play Elixir library that seamlessly integrates PostgreSQL’s search into Ecto, streamlining the construction of advanced search queries. The goal is to help developers create Ecto queries that return …

---

## [Alexey Kondratenko - Ukraine, Software Engineer. More than 8 years of E-commerce development experience. Elixir Phoenix Ruby Ruby on Rails](https://forum.elixirforum.com/t/alexey-kondratenko-ukraine-software-engineer-more-than-8-years-of-e-commerce-development-experience-elixir-phoenix-ruby-ruby-on-rails/76172)

<div class="topic-metadata">

**Author:** [@Alexey](https://forum.elixirforum.com/u/Alexey)\
**Replies:** 0\
**Last updated:** [July 29, 2026, 3:13pm UTC](https://forum.elixirforum.com/t/alexey-kondratenko-ukraine-software-engineer-more-than-8-years-of-e-commerce-development-experience-elixir-phoenix-ruby-ruby-on-rails/76172 "2026-07-29T15:13:39Z")

</div>

Alexey Kondratenko PERSONAL DETAILS Email: ialexey.kondratenko@gmail.com Location: Ukraine, Kiev LinkedIn: Alexey Kondratenko – Ukraine | Професійний профіль | LinkedIn GitHub: AlexeyAlexey / Repositories · GitHub …

---

## [Search\_ash - multilingual Postgres full-text search for Ash](https://forum.elixirforum.com/t/search-ash-multilingual-postgres-full-text-search-for-ash/76033)

<div class="topic-metadata">

**Author:** [@nseaSeb](https://forum.elixirforum.com/u/nseaSeb)\
**Replies:** 8\
**Last updated:** [July 21, 2026, 4:06pm UTC](https://forum.elixirforum.com/t/search-ash-multilingual-postgres-full-text-search-for-ash/76033 "2026-07-21T16:06:46Z")

</div>

search\_ash — multilingual Postgres full-text search for Ash Hi everyone, I’m building a multi-tenant SaaS (Ash + LiveView + Postgres) and needed a global search across several entity types — products, customers, orders…

---

## [Getting tsvectors: error\] \*\* (Postgrex.Error) ERROR 42703 (undefined\_column) record “new” has no field “business\_id”](https://forum.elixirforum.com/t/getting-tsvectors-error-postgrex-error-error-42703-undefined-column-record-new-has-no-field-business-id/75910)

<div class="topic-metadata">

**Author:** [@hakarabakara1](https://forum.elixirforum.com/u/hakarabakara1)\
**Replies:** 1\
**Last updated:** [July 6, 2026, 4:44pm UTC](https://forum.elixirforum.com/t/getting-tsvectors-error-postgrex-error-error-42703-undefined-column-record-new-has-no-field-business-id/75910 "2026-07-06T16:44:14Z")

</div>

I have three modules, a Business which is associated Tags and Categories though join tables business\_tags and business\_categories. I intent to improve search hits on the business using tsvector on the database and I have…

---

## [Handling Race Conditions in an Event Ticketing System with Oban](https://forum.elixirforum.com/t/handling-race-conditions-in-an-event-ticketing-system-with-oban/75295)

<div class="topic-metadata">

**Author:** [@mik284](https://forum.elixirforum.com/u/mik284)\
**Replies:** 2\
**Last updated:** [May 13, 2026, 10:07am UTC](https://forum.elixirforum.com/t/handling-race-conditions-in-an-event-ticketing-system-with-oban/75295 "2026-05-13T10:07:25Z")

</div>

I’m currently building an event ticketing system in Elixir and I’m looking for advice on properly handling race conditions around ticket inventory. I’m using Oban for background processing with jobs responsible for: I…

---

## [Seeking architecture feedback on a governed execution platform for AI workloads on the BEAM](https://forum.elixirforum.com/t/seeking-architecture-feedback-on-a-governed-execution-platform-for-ai-workloads-on-the-beam/75059)

<div class="topic-metadata">

**Author:** [@gtcode](https://forum.elixirforum.com/u/gtcode)\
**Replies:** 2\
**Last updated:** [April 21, 2026, 11:04pm UTC](https://forum.elixirforum.com/t/seeking-architecture-feedback-on-a-governed-execution-platform-for-ai-workloads-on-the-beam/75059 "2026-04-21T23:04:57Z")

</div>

Hi everyone, I have been working on a large-scale, open-source platform for orchestrating and governing AI workloads on the BEAM (currently spanning various repositories under North-Shore-AI / nshkrdotcom). Because AI …

---

## [How to migrate multiple migrations files in a single transaction?](https://forum.elixirforum.com/t/how-to-migrate-multiple-migrations-files-in-a-single-transaction/74908)

<div class="topic-metadata">

**Author:** [@sezaru](https://forum.elixirforum.com/u/sezaru)\
**Replies:** 8\
**Last updated:** [April 7, 2026, 4:51pm UTC](https://forum.elixirforum.com/t/how-to-migrate-multiple-migrations-files-in-a-single-transaction/74908 "2026-04-07T16:51:12Z")

</div>

I’ve been wondering for some time now if there is a way to instruct ecto to run all, not yet applied, migrations inside a single transaction. For example, let’s say I have two migrations: 20260406204201\_remove\_some\_stu…

---

## [Oban - Reliable and Observable Job Processing](https://forum.elixirforum.com/t/oban-reliable-and-observable-job-processing/22449)

<div class="topic-metadata">

**Author:** [@sorentwo](https://forum.elixirforum.com/u/sorentwo)\
**Replies:** 311\
**Last updated:** [March 25, 2026, 3:49pm UTC](https://forum.elixirforum.com/t/oban-reliable-and-observable-job-processing/22449 "2026-03-25T15:49:12Z")

</div>

Hello! tl;dr Announcing Oban, an Ecto based job processing library with a focus on reliability and historical observability. After spending nearly a year building Kiq, an Elixir port of Sidekiq with most of the bells a…

---

## [pgRx - PostgreSQL-compatible query engine built on BEAM + Rust](https://forum.elixirforum.com/t/pgrx-postgresql-compatible-query-engine-built-on-beam-rust/74775)

<div class="topic-metadata">

**Author:** [@WyvernoDragon](https://forum.elixirforum.com/u/WyvernoDragon)\
**Replies:** 0\
**Last updated:** [March 25, 2026, 1:14am UTC](https://forum.elixirforum.com/t/pgrx-postgresql-compatible-query-engine-built-on-beam-rust/74775 "2026-03-25T01:14:31Z")

</div>

I’ve been working on pgRx: a query engine that uses BEAM lightweight processes instead of PostgreSQL’s fork-per-connection model. The numbers: 50 idle connections cost PostgreSQL 729MB additional memory. On pgRx it’s 0K…

---

## [Citext extension and making case-insensitive columns in PostGresQL](https://forum.elixirforum.com/t/citext-extension-and-making-case-insensitive-columns-in-postgresql/19753)

<div class="topic-metadata">

**Author:** [@fireproofsocks](https://forum.elixirforum.com/u/fireproofsocks)\
**Replies:** 8\
**Last updated:** [March 17, 2026, 6:58am UTC](https://forum.elixirforum.com/t/citext-extension-and-making-case-insensitive-columns-in-postgresql/19753 "2026-03-17T06:58:51Z")

</div>

Building off of this older post: What I need to do is to create a few case-insensitive columns in PostGres. I’ve been following this post: Case insensitive column in Phoenix | Adam Niedzielski but somehow I always seem…

---

## [Fly.io + Supabase DB: Too many connections after releases](https://forum.elixirforum.com/t/fly-io-supabase-db-too-many-connections-after-releases/74494)

<div class="topic-metadata">

**Author:** [@ajur58](https://forum.elixirforum.com/u/ajur58)\
**Replies:** 0\
**Last updated:** [March 3, 2026, 12:03pm UTC](https://forum.elixirforum.com/t/fly-io-supabase-db-too-many-connections-after-releases/74494 "2026-03-03T12:03:21Z")

</div>

Hi everyone, I’m posting because I assume this must be a common issue, but I’ve been going in circles and haven’t found a clean, reliable pattern yet. I run a fairly simple Phoenix app on Fly.io with a rolling deploy …

---

## [Using UUIDv7 with Ecto and PostgreSQL](https://forum.elixirforum.com/t/using-uuidv7-with-ecto-and-postgresql/74208)

<div class="topic-metadata">

**Author:** [@matt-savvy](https://forum.elixirforum.com/u/matt-savvy)\
**Replies:** 1\
**Last updated:** [February 5, 2026, 7:57am UTC](https://forum.elixirforum.com/t/using-uuidv7-with-ecto-and-postgresql/74208 "2026-02-05T07:57:24Z")

</div>

Postgres 18 adds support for generating UUIDv7s out of the box; no extensions required. Unfortunately, it’s less obvious how to use these for the id in our Ecto schemas. But don’t worry, it only requires a few small chan…

---

## [Thinking Elixir 290 - Postgres Finally Gets Real Search](https://forum.elixirforum.com/t/thinking-elixir-290-postgres-finally-gets-real-search/74183)

<div class="topic-metadata">

**Author:** [@brainlid](https://forum.elixirforum.com/u/brainlid)\
**Replies:** 0\
**Last updated:** [February 3, 2026, 1:26pm UTC](https://forum.elixirforum.com/t/thinking-elixir-290-postgres-finally-gets-real-search/74183 "2026-02-03T13:26:17Z")

</div>

Episode 290 of Thinking Elixir. News includes Elixir v1.20.0-rc.1 with important type system improvements, not one but two new Elixir-native Bash interpreters for seamless interop, LiveCapture bringing zero-boilerplate s…

---

## [Blink - Fast bulk seeding for Ecto/PostgreSQL with clean, declarative syntax](https://forum.elixirforum.com/t/blink-fast-bulk-seeding-for-ecto-postgresql-with-clean-declarative-syntax/73935)

<div class="topic-metadata">

**Author:** [@coen.bakker](https://forum.elixirforum.com/u/coen.bakker)\
**Replies:** 6\
**Last updated:** [February 1, 2026, 1:38pm UTC](https://forum.elixirforum.com/t/blink-fast-bulk-seeding-for-ecto-postgresql-with-clean-declarative-syntax/73935 "2026-02-01T13:38:01Z")

</div>

Blink is a library for fast bulk data insertion into PostgreSQL databases using the COPY command. It provides a clean, declarative syntax for defining seeders. Features: Uses PostgreSQL’s COPY for fast bulk inserts Ta…

---

## [Querying an array of ints in PostgreSQL using Ecto](https://forum.elixirforum.com/t/querying-an-array-of-ints-in-postgresql-using-ecto/69016)

<div class="topic-metadata">

**Author:** [@avilesj](https://forum.elixirforum.com/u/avilesj)\
**Replies:** 3\
**Last updated:** [January 21, 2026, 2:21pm UTC](https://forum.elixirforum.com/t/querying-an-array-of-ints-in-postgresql-using-ecto/69016 "2026-01-21T14:21:25Z")

</div>

Hello community. I am trying to perform the following query in Ecto SELECT \* FROM table t where ARRAY\[2, 12\] \<@ list\_of\_ids ; The closest I have gotten to is from t in Table, where: fragment("ARRAY\[?\] \<@ ?", ^list\_o…

---

## [Thinking Elixir 285 - From Popcorn to Robots](https://forum.elixirforum.com/t/thinking-elixir-285-from-popcorn-to-robots/73817)

<div class="topic-metadata">

**Author:** [@brainlid](https://forum.elixirforum.com/u/brainlid)\
**Replies:** 2\
**Last updated:** [January 13, 2026, 2:44pm UTC](https://forum.elixirforum.com/t/thinking-elixir-285-from-popcorn-to-robots/73817 "2026-01-13T14:44:16Z")

</div>

Episode 285 of Thinking Elixir. News includes Software Mansion pushing the boundaries of Popcorn by running LiveView locally in the browser using WebAssembly, the Programming Nerves book by Alex Koutmos and Hugo Baraúna …

---

## [What are the differences or pros/cons between FreeBSD and Linux for PostgreSQL hosting?](https://forum.elixirforum.com/t/what-are-the-differences-or-pros-cons-between-freebsd-and-linux-for-postgresql-hosting/73860)

<div class="topic-metadata">

**Author:** [@cevado](https://forum.elixirforum.com/u/cevado)\
**Replies:** 0\
**Last updated:** [January 2, 2026, 1:37pm UTC](https://forum.elixirforum.com/t/what-are-the-differences-or-pros-cons-between-freebsd-and-linux-for-postgresql-hosting/73860 "2026-01-02T13:37:42Z")

</div>

I was reading postgres wiki about freebsd and freebsd/aio and it wasn’t clear to me what is better, the same or worse compared to hosting it on linux. i’m not focused on the fine tuning side of it. i was just curious on …

---

## [Extensions in ash\_postgres database](https://forum.elixirforum.com/t/extensions-in-ash-postgres-database/73701)

<div class="topic-metadata">

**Author:** [@samoloth](https://forum.elixirforum.com/u/samoloth)\
**Replies:** 2\
**Last updated:** [December 22, 2025, 12:08pm UTC](https://forum.elixirforum.com/t/extensions-in-ash-postgres-database/73701 "2025-12-22T12:08:46Z")

</div>

Hi, since my project will require some analytics, I’ve decided to use Postgres + DuckDB via pg\_duckdb extension. I’ve spinned up an official pgduckdb container, set up credentials, run mix ash.reset, added pg\_duckdb to i…

---

## [Encode array of ecto type that maps to a postgres composite type](https://forum.elixirforum.com/t/encode-array-of-ecto-type-that-maps-to-a-postgres-composite-type/73505)

<div class="topic-metadata">

**Author:** [@thenrio](https://forum.elixirforum.com/u/thenrio)\
**Replies:** 2\
**Last updated:** [December 8, 2025, 2:43pm UTC](https://forum.elixirforum.com/t/encode-array-of-ecto-type-that-maps-to-a-postgres-composite-type/73505 "2025-12-08T14:43:53Z")

</div>

I have an Ecto.Type Size that maps to postgres composite type size. I can encode a Size parameter but can’t encode an array of Size. Here some details, the postgres type CREATE TYPE size AS (value numeric, unit varch…

---

## [Thinking Elixir 280 - Dark Matter Developers](https://forum.elixirforum.com/t/thinking-elixir-280-dark-matter-developers/73447)

<div class="topic-metadata">

**Author:** [@brainlid](https://forum.elixirforum.com/u/brainlid)\
**Replies:** 0\
**Last updated:** [November 25, 2025, 1:01pm UTC](https://forum.elixirforum.com/t/thinking-elixir-280-dark-matter-developers/73447 "2025-11-25T13:01:08Z")

</div>

Episode 280 of Thinking Elixir. News includes Elixir 1.19.3 point release with enhanced regular expression support in config files, Tidewave Web adding support for Claude Code and OpenAI Codex agents, Hologram’s JavaScri…

---

## [Large Object feature of Postgres](https://forum.elixirforum.com/t/large-object-feature-of-postgres/25571)

<div class="topic-metadata">

**Author:** [@shijith.k](https://forum.elixirforum.com/u/shijith.k)\
**Replies:** 4\
**Last updated:** [November 11, 2025, 8:12pm UTC](https://forum.elixirforum.com/t/large-object-feature-of-postgres/25571 "2025-11-11T20:12:46Z")

</div>

Has anyone ever tried out the Large Object feature of Postgres? I have a blob column in my table, and was wondering what data type to use, and that’s when I came across :bytea and this Large Object feature. Since :bytea …

---

## [Thinking Elixir 278 - WAL-ing Through Database Changes](https://forum.elixirforum.com/t/thinking-elixir-278-wal-ing-through-database-changes/73274)

<div class="topic-metadata">

**Author:** [@brainlid](https://forum.elixirforum.com/u/brainlid)\
**Replies:** 0\
**Last updated:** [November 11, 2025, 1:58pm UTC](https://forum.elixirforum.com/t/thinking-elixir-278-wal-ing-through-database-changes/73274 "2025-11-11T13:58:34Z")

</div>

Episode 278 of Thinking Elixir. News includes the Curiosum Elixir survey closing soon, ReqLLM reaching 1.0 with standardized LLM API support across multiple providers, Isaac Yonemoto’s Codicil library bringing semantic c…

---

## [Listen to Database Changes through the Postgres WAL](https://forum.elixirforum.com/t/listen-to-database-changes-through-the-postgres-wal/73179)

<div class="topic-metadata">

**Author:** [@PJUllrich](https://forum.elixirforum.com/u/PJUllrich)\
**Replies:** 0\
**Last updated:** [November 3, 2025, 6:18pm UTC](https://forum.elixirforum.com/t/listen-to-database-changes-through-the-postgres-wal/73179 "2025-11-03T18:18:43Z")

</div>

This deep-dive into Postgres’ Write-Ahead Log (WAL) covers how to track database changes without changing a single line of application code!

[Next page](https://forum.elixirforum.com/tag/postgres/285.md?match_all_tags=true&page=1&tags%5B%5D=postgres)
