JS - JobScheduler
  1. JS - JobScheduler
  2. JS-781

"SCHEDULER-451 Database check failed, database is not useable" for Postgres if the parameter "standard_conforming_strings" is turned on

    Details

      Description

      General

      • Since Postgres Version 9.1 the parameter standard_conforming_strings is turn on.
      • This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. The JobScheduler may check this parameter to determine how string literals will be processed. The presence of this parameter can also be taken as an indication that the escape string syntax (E'...') is supported. Escape string syntax should be used if the JobScheduler desires backslashes to be treated as escape characters.
      • See also http://www.depesz.com/index.php/2010/07/21/waiting-for-9-1-standard_conforming_strings-on/

      Current Situation

      • The JobScheduler has a special implementation to escape strings for Postgres because Postgres < 9.1 has a non SQL standard default behavior.
      • This default behavior in Postgres has change with version 9.1. so that it is necessary to set the Postgres system variable standard_conforming_strings=off
        see https://kb.sos-berlin.com/x/BYM3

      Desired behavior

      • The JobScheduler use for Postgres the SQL standard escaping.

      Note

      • All users which use the JobScheduler since above "fix version" with Postgres has to (re)set the Postgres system variable standard_conforming_strings=on.
      • use show standard_conforming_strings; to check the setting.

        Issue Links

          Activity

          Hide
          Christophe Migliorini added a comment - - edited

          comment deleted. Apparently the role was modified so my postgresql.conf was overridden. Sorry about that

          Show
          Christophe Migliorini added a comment - - edited comment deleted. Apparently the role was modified so my postgresql.conf was overridden. Sorry about that

            People

            • Assignee:
              Joacim Zschimmer
              Reporter:
              Oliver Haufe
              Approver:
              Oliver Haufe
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 3 days
                3d
                Remaining:
                Remaining Estimate - 3 days
                3d
                Logged:
                Time Spent - Not Specified
                Not Specified