Create postgresql extension when deploying to gigalixir

Phoenix Forum Questions / Help
,
1 
14:36:20.654 [info] == Running 20190906134236 Stipe.Repo.Migrations.CreateUsers.change/0 forward
14:36:20.655 [info] execute "CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;"
▸  Given the following expression: Ecto.Migrator.run(List.first(Application.get_env(:stipe, :ecto_repos)), Application.app_dir(:stipe, "priv/repo/migrations"), :up, all: true)
▸  The remote call failed with:
▸  ** (exit) %Postgrex.Error{connection_id: 27669, message: nil, postgres: %{code: :insufficient_privilege, file: "extension.c", hint: "Must be superuser to create this extension.", line: "792", message: "permission denied to create extension \"citext\"", pg_code: "42501", routine: "execute_extension_script", severity: "ERROR"}, query: nil}

How do I create postgresql extension when deploying to gigalixir free account?

It looks like I dont have enough privilege

2

My assumption were that it’s not possible, and I’d check if it’s available in the paid plan.

But perhaps @jesse can give you a better answer?

2 Likes
3

Yeah, sorry about that. It’s available on standard dbs, but not free dbs.
See the db section here
https://gigalixir.readthedocs.io/en/latest/main.html#tiers

3 Likes
4

thanks. Do you know why postgresql extensions are not included?