Server Variable standard_conforming_strings
Since Postgres version 9.1 the parameter standard_conforming_strings is turn on.
It controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. This behaviour is different to verions before 9.1 and JobScheduler will throw an exception. To avoid it turn standard_conforming_strings in your Postgres configuration to off.
It has always been recommended to set this parameter to on.
For all those that 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
Server Variable bytea_output
Since Postgres version 9.1 the parameter bytea_output is set to hex.
This settings must be changed to escape.
For all those that do not want to change this globally, this setting can be changed on a per user level:
alter user scheduler set bytea_output = 'escape'