search

gigalixir / gigalixir-cli

MIT License
52 stars 45 forks source link

Postgis migration #21

Closed AzimLord closed 6 years ago

AzimLord commented 6 years ago

Hi guys. Im getting this error when running gigalixir ps:migrate

07:37:49.130 [info] == Running ProjectName.Repo.Migrations.EnablePostgis.up/0 forward 07:37:49.130 [info] execute "CREATE EXTENSION IF NOT EXISTS postgis" ▸ Given the following expression: Ecto.Migrator.run(List.first(Application.get_env(:project_onz, :ecto_repos)), Application.app_dir(:project_onz, "priv/repo/migrations"), :up,all: true) ▸ The remote call failed with: ▸ ** (exit) %Postgrex.Error{connection_id: 25320, message: nil, postgres: %{code: :undefined_file, file: "extension.c", line: "478", message: "could not open extension controlfile \"/usr/share/postgresql/9.5/extension/postgis.control\": No such file or directory", pg_code: "58P01", routine: "parse_extension_control_file", severity: "ERROR"}} ▸ (ecto) lib/ecto/adapters/sql.ex:200: Ecto.Adapters.SQL.query!/5 ▸ (ecto) lib/ecto/adapters/postgres.ex:96: anonymous fn/4 in Ecto.Adapters.Postgres.execute_ddl/3 ▸ (elixir) lib/enum.ex:1811: Enum."-reduce/3-lists^foldl/2-0-"/3 ▸ (ecto) lib/ecto/adapters/postgres.ex:96: Ecto.Adapters.Postgres.execute_ddl/3 ▸ (ecto) lib/ecto/migration/runner.ex:104: anonymous fn/2 in Ecto.Migration.Runner.flush/0 ▸ (elixir) lib/enum.ex:1811: Enum."-reduce/3-lists^foldl/2-0-"/3 ▸ (ecto) lib/ecto/migration/runner.ex:102: Ecto.Migration.Runner.flush/0 ▸ (stdlib) timer.erl:181: :timer.tc/2

Im usinggeo_postgis, "~> 1.1.0 in my project

Please help

jesseshieh commented 6 years ago

Hey @AzimLord, unfortunately extensions aren't supported on the gigalixir free tier postgres databases. See tier descriptions https://gigalixir.readthedocs.io/en/latest/main.html#tiers

If you need extensions, you'll need to upgrade to the standard tier and create a new standard tier database. See https://gigalixir.readthedocs.io/en/latest/main.html#how-to-install-a-postgres-extension

Hope this helps.