Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-10689

puppetlabs/postgresql : postgresql_conn_validator requires explicit configuration of psql_path

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: postgresql
    • Labels:
      None
    • Template:
      MODULES Bug Template
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      Basic Info
      Module Version: 6.5.0
      Puppet Version: 5.5.20
      OS Name/Version: Ubuntu 18.04

      Describe your issue in as much detail as possible...

      Desired Behavior: When using the postgresql_conn_validator resource only the absolutely necessary parameters should be required. The default value of psql_path of this resource type should be the global one (postgresql::globals::psql_path or postgresql::server::psql_path)

      Actual Behavior: Configuration of psql_path for every postgresql_conn_validator is required (or resource defaults must be used).

      Puppet code:

      postgresql_conn_validator { 'validate_db_connection':
       run_as => 'postgres',
       db_username => 'postgres',
       db_name => 'postgres',
       }

       

      Debug output:

      Debug: PostgresqlValidator.attempt_connection: Attempting connection to postgres
      Debug: PostgresqlValidator.attempt_connection: --tuples-only --quiet --no-psqlrc --username postgres --dbname postgres --command 'SELECT 1' 
      Debug: Executing with uid=postgres: ' --tuples-only --quiet --no-psqlrc --username postgres --dbname postgres --command 'SELECT 1' '

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            criegg Claus-Theodor Riegg
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Zendesk Support