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