We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
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