Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-12267

Correctly interpret postgres:// schema in System database URL

XMLWordPrintable

    • Icon: Story Story
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • None
    • System
    • None
    • False
    • Hide

      None

      Show
      None
    • False
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started

      In System (porta) database configuration we apply PostgreSQL-specific configuration if the database connection string starts with "postgresql", see https://github.com/3scale/porta/blob/cfe45001b1f88982ffffcc112748d953008db96b/config/examples/database.yml#L20

      However, according to the PostgreSQL documentation, postgres:// is also a valid schema for the connection string: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS

      The URI scheme designator can be either postgresql:// or postgres://.

      So the request is to change the pattern in the database.yml to /^postgres/.

              Unassigned Unassigned
              rhn-support-dmayorov Daria Mayorova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: