Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCUMENT-674

External PostgreSQL steps differ between pages.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Done
    • Component/s: PuppetDB
    • Labels:
      None
    • Template:
    • QA Risk Assessment:
      Needs Assessment

      Description

      There are two documents for installing an external PostgreSQL. There is a major difference in the steps, where one-page states that the pgcrypto extension needs to be installed to the PE-RBAC instance and the other does not. This has caused a prospect to have an issue getting an external DB setup and to authenticate to the PE console.

      Can the code on the second link be updated to include the pgcrypto extension installation?

      1. https://docs.puppet.com/pe/2017.2/sys_req_extsql.html

      Install the pgcrypto extension on the PuppetDB and RBAC databases. To install the extension, run the following commands:
       
      sudo -u postgres sh
      psql puppetdb -c 'create extension pgcrypto'
      psql pe_rbac -c 'create extension pgcrypto'
      exit
      

      2. https://docs.puppet.com/pe/2017.2/install_external_postgresql.html

      \c "pe-rbac"
      CREATE EXTENSION citext;
      CREATE EXTENSION pg_trgm;
      CREATE EXTENSION plpgsql;
      
      

        Attachments

          Activity

            jsd-sla-details-panel

              People

              • Assignee:
                melissa.amos Melissa Amos
                Reporter:
                tommy Thomas Speigner
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: