Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-2951

Handle missing postgresql-contrib gracefully

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Normal
    • Resolution: Done
    • None
    • PDB 5.2.6, PDB 6.0.1
    • PuppetDB
    • None
    • PuppetDB
    • Not Needed

    Description

      A user encountered this error on Centos 6.7 while upgrading to 4.2.0 from the previous version:
      http://pastebin.com/UEB5YSxQ

      looking at the postgres logs showed

      14:54 <jdehnert> From postgres.. < 2016-08-10 14:03:04.523 PDT >ERROR: could not access file "$libdir/pg_trgm": No such file or directory
      14:54 <jdehnert> < 2016-08-10 14:03:04.523 PDT >STATEMENT: CREATE INDEX fact_values_string_trgm ON fact_values USING gin (value_string gin_tr
      14:54 <jdehnert> gm_ops)

      Installing postgresql-contrib resolved it, but we need to make sure we're handling the case where that package is missing and also figure out why (sutils/pg-extension? "pg_trgm") returned truthy.

      Attachments

        Activity

          People

            austin.blatt Austin Blatt
            wyatt Wyatt Alt
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Zendesk Support