Trying to enable `postgis` but getting ` ** (DBConnection.ConnectionError) tcp recv: closed` when executing

I’m using postgis and after reading Deploying postgis it was my understanding that I could just enable it in the migration file by running.

CREATE EXTENSION IF NOT EXISTS postgis

However when deploying I get the following error.

  ** (DBConnection.ConnectionError) tcp recv: closed
      (db_connection 2.5.0) lib/db_connection.ex:1665: DBConnection.run_transaction/4
      (ecto_sql 3.10.2) lib/ecto/adapters/postgres.ex:282: Ecto.Adapters.Postgres.do_lock_for_migrations/5
      (ecto_sql 3.10.2) lib/ecto/migrator.ex:586: Ecto.Migrator.lock_for_migrations/4
      (ecto_sql 3.10.2) lib/ecto/migrator.ex:734: anonymous fn/5 in Ecto.Migrator.migrate/4
      (elixir 1.15.2) lib/enum.ex:2510: Enum."-reduce/3-lists^foldl/2-0-"/3
      (ecto_sql 3.10.2) lib/ecto/migrator.ex:733: Ecto.Migrator.migrate/4
      (ecto_sql 3.10.2) lib/ecto/migrator.ex:170: Ecto.Migrator.with_repo/3
      nofile:1: (file)

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.