You are viewing an old version of this page. View the current version.

    Compare with Current View Page History

    « Previous Version 14 Current »

    Icon

    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 two SQL statements, and should be done after the supervisor installation has been performed.

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

    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.

    • No labels