Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-34496

provide option to include PostgreSQL database side config settings in the product support zip

    Details

    • Type: Improvement
    • Status: New
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.40.1
    • Fix Version/s: None
    • Component/s: Support Tools
    • Labels:
    • Notability:
      n/a

      Description

      When Nexus Repo is connected to a PostgreSQL database, some product issues can be better understood or diagnosed if the product support team knows all the PostgreSQL side database settings active.

      A support zip generated from the product and that is sent to Sonatype product support team could contain a file with this information so that product support team does not have to explicitly ask for it.

      Essentially the settings equivalent to what one would generate with commands like this:

      psql -d <database_name> -c "\copy (Select * From pg_settings) To './pg_settings.csv' With CSV"
      

      Expected

      A generated product support zip contains all the PostgreSQL side configured and active settings. Render these in their own easily parseable file ( may be formatted json or even simple txt format with a setting per line).

      If the settings would include any password style information, make a strong effort to obfuscate such data. ( not sure that is even a thing )

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            plynch Peter Lynch
            Last Updated By:
            Michael Oliverio Michael Oliverio
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                tigCommentSecurity.panel-title