Upgrade from 1.0-6 to 1.0-7 --------------------------- You have to update your host table with master_password Each host/ip can have different password. --------8<------------8<----------------- ALTER TABLE host ADD COLUMN pass varchar(32); UPDATE host SET pass = 'your_password' ; ALTER TABLE host ALTER pass SET not null ; --------8<------------8<----------------- host.ip (char) -> host.ip(inet) add xfer_port --------8<------------8<----------------- ALTER TABLE host ADD column xfer_port int DEFAULT 5545 ; ALTER TABLE host RENAME ip TO ip_tmp ; ALTER TABLE host ADD column ip inet ; UPDATE host set ip=inet(ip_tmp); ALTER TABLE host DROP COLUMN ip_tmp ; CREATE UNIQUE INDEX host_idx ON host USING BTREE (name, ip) ; --------8<------------8<----------------- Upgrade from 1.0-4 to 1.0-5 --------------------------- Past this to a psql session on sched database --------8<------------8<----------------- CREATE TABLE task_notify ( task_sid varchar(255) REFERENCES task_hist (task_sid) ON DELETE CASCADE, host varchar(255), date timestamp, primary key(task_sid, host) ) ; CREATE INDEX job_hist_start_date_idx ON job_hist USING BTREE (start_date) ; CREATE INDEX job_hist_end_date_idx ON job_hist USING BTREE (end_date) ; --------8<------------8<-----------------