Server Variable standard_conforming_strings
Since Postgres version 9.1 the parameter standard_conforming_strings is turned on.
It controls whether ordinary string literals ('...') treat backslashes literally as specified in the SQL standard. This behaviour is different to versions before 9.1 and JobScheduler will throw an exception. To avoid this, turn off standard_conforming_strings in your PostgresSQL configuration.
For those who do not want to change this globally, this setting can be changed on a per user level:
alter user scheduler set standard_conforming_strings = off
Since JobScheduler release 1.10.5 the default standard_conforming_strings = on is required.
JS-781 - Getting issue details... STATUS
Server Variable bytea_output
Since PostgreSQL version 9.1 the parameter bytea_output defaults to hex.
This setting should be modified to the value: escape.
For those who do not want to change this globally, this setting can be changed on a user level:
alter user scheduler set bytea_output = 'escape'