Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-65717

Update Connecting Postgres documentation with search_path

    • 1
    • 7
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Problem Definition

      Currently, it is have stated that:

      PostgreSQL 7.2 and later require a schema to be specified in the <schema-name/> element. If your PostgreSQL database uses the default 'public' schema, this should be specified in the <schema-name/> element as shown below. Ensure that your database schema name is lower-case, as JIRA cannot work with PostgreSQL databases whose schema names contain upper-case characters.

      From the official PSQL documentation, when using a schema other than public, DBA needs to update the search_path to include the new schema.

      Suggested Solution

      Update the documentation to include this information.

      Note

      A bug that is affected by this is JRASERVER-64886.

          Form Name

            [JRASERVER-65717] Update Connecting Postgres documentation with search_path

            Robert Klimkiewicz made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Robert Klimkiewicz made changes -
            Status Original: In Progress [ 3 ] New: Waiting for Release [ 12075 ]
            Robert Klimkiewicz made changes -
            PM Reviewed New: 16/May/2025
            Status Original: Gathering Interest [ 11772 ] New: In Progress [ 3 ]
            Robert Klimkiewicz made changes -
            Assignee Original: Wazza [ wthompson ] New: Robert Klimkiewicz [ 94e733e73fd4 ]
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 1017261 ]
            SET Analytics Bot made changes -
            Support reference count Original: 2 New: 7
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0

              94e733e73fd4 Robert Klimkiewicz
              mmuthusamy Moga
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: