Superuser is needed in some applications

ansibleplaybookbundle / postgresql-apb

An APB which deploys an RHSCL PostgreSQL instance

8 stars 12 forks source link

Superuser is needed in some applications #48

Closed rgordill closed 2 years ago

rgordill commented 6 years ago

Hi.

I am using some apps, that are raising the following issue: Database Setup Failed. Please report this to support: (psycopg2.ProgrammingError) permission denied to create extension "pg_trgm" HINT: Must be superuser to create this extension. [SQL: 'CREATE EXTENSION IF NOT EXISTS pg_trgm']

What can we do to support it OOTB?

Maybe using POSTGRESQL_ADMIN_PASSWORD?

rgordill commented 2 years ago

Not needed anymore.