Home Posts Tags Post Search Tag Search

Post 80

Ash Framework 09 - Migration Issue

Published on: 2025-10-16 Tags: elixir, Blog, Side Project, Testing, LiveView, Ecto, Html/CSS, Phoenix, Ash, Framework
Fixing "pg-trgm" Error
        ** (Postgrex.Error) ERROR 0A000 (feature_not_supported) extension "pg-trgm" is not available

        hint: The extension must first be installed on the system where PostgreSQL is running.

        Want to figure out why this is not working need to test this for the tunez_test db.

        sudo nano /etc/postgresql/17/main/pg_hba.conf

        Okay so just so its here I changed some things in this file so md5 so that it asks me for a password in order to use psql, that made it possible to test more things but it wasn't the issue.

        The issue was the line in my pg_trgm migration. It was with " and - not _ once I fixed that I was able to get it to work every time here is the final line.
            def up do
                execute("CREATE EXTENSION IF NOT EXISTS pg_trgm")
            end