Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: NixOS/hydra
base: 8c9aec5f1266
Choose a base ref
...
head repository: NixOS/hydra
compare: 5e9439e7745c
Choose a head ref
  • 3 commits
  • 3 files changed
  • 2 contributors

Commits on Jul 25, 2019

  1. sql: refactor some sql statements to lowercase

    @nlewo
    nlewo committed Jul 25, 2019
    Copy the full SHA
    42784a9 View commit details
    Browse the repository at this point in the history

  2. Create extension pg_trgm in the NixOS module 

    The creation of the `pg_trgm` extension needs superuser power. So,
this patch makes the extension creation in the Hydra NixOS module when
a local database is used.

If it is not possible to create this extension (remote database for
instance with nosuperuser), the creation of the `pg_trgm` index is
skipped (this index speedup queries on builds.drvpath) and warnings
are emitted:

    initialising the Hydra database schema...
    WARNING:  Can not create extension pg_trgm: permission denied to create extension "pg_trgm"
    WARNING:  HINT: Temporary provide superuser role to your Hydra Postgresql user and run the script src/sql/upgrade-57.sql
    WARNING:  The pg_trgm index on builds.drvpath has been skipped (slower complex queries on builds.drvpath)

This allows to keep smooth migrations: the migration process doesn't
require a manual step (but this manual step is recommended on big
remote databases).
    @nlewo
    nlewo committed Jul 25, 2019
    Copy the full SHA
    8a0a5ec View commit details
    Browse the repository at this point in the history

  3. Merge pull request #657 from nlewo/create-pg-trgm-in-module 

    Create `pg_trgm` extension in the NixOS module
    @edolstra
    edolstra committed Jul 25, 2019
    Copy the full SHA
    5e9439e View commit details
    Browse the repository at this point in the history