...
To start numbering new jobs at 1001, run the following:
...
| Code Block | ||
|---|---|---|
| ||
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.