Versions Compared

    Key

    • This line was added.
    • This line was removed.
    • Formatting was changed.
    Note

    Please note that it's not possible to move the starting job id backwards (to a lower number than is currently in use), you can only move it forward to a higher number.

    This has to be done with an two SQL statementstatements, and should be done after the supervisor installation has been performed.

    To start numbering new jobs at 1001, run the following:

    ...

    Code Block
    languagesql
     psql -p 50055 -U pfx -d pfx -c "UPDATE qube.jobidmax SET id=1000; INSERT INTO qube.jobid (id,realid,serverid) VALUES(1000,1000,0); ALTER SEQUENCE qube.jobid_id_seq RESTART WITH 1001"

    This can be done on a running supervisor, there's no need to stop it before executing this statement, but it should be done while no users are submitting jobs.