hydra-init fails because: permission denied to create extension "pg_trgm"

[basvandijk]

@nlewo after upgrading hydra to the latest master (c85bf66) I get the following error when starting hydra:

Jun 25 11:57:16 hydra systemd[1]: Starting hydra-init.service...
Jun 25 11:57:17 hydra hydra-init[19351]: upgrading Hydra schema from version 56 to 57
Jun 25 11:57:17 hydra hydra-init[19351]: executing SQL statement: CREATE EXTENSION pg_trgm
Jun 25 11:57:17 hydra hydra-init[19351]: schema upgrade failed: main::run_(): DBI Exception: DBD::Pg::db do failed: ERROR:  permission denied to create extension "pg_trgm"
Jun 25 11:57:17 hydra hydra-init[19351]: HINT:  Must be superuser to create this extension. at /nix/store/0mgikix3jzg1971yndzsjqqgzfjwbv75-hydra-0.1.2544.c85bf6/bin/.hydra-init-wrapped line 59
Jun 25 11:57:17 hydra systemd[1]: hydra-init.service: Main process exited, code=exited, status=255/n/a
Jun 25 11:57:17 hydra systemd[1]: hydra-init.service: Failed with result 'exit-code'.
Jun 25 11:57:17 hydra systemd[1]: Failed to start hydra-init.service.

I see the pg_trgm PostgreSQL extension was added in: 7935cff.

Does the hydra NixOS module need to be updated to make this work?

[edolstra]

Yes, see #657.

[basvandijk]

Thanks! I think that PR will fix my problem.

[nlewo]

@basvandijk sorry for this issue:(
Let me know if you still have issues with PR #657.