3 # Shell script to update PostgreSQL tables from version 1.38 to 1.39
6 echo "This script will update a Bacula PostgreSQL database from version 9 to 9"
7 echo "Depending on the size of your database,"
8 echo "this script may take several minutes to run."
12 if $bindir/psql -f - -d bacula $* <<END-OF-DATA
14 ALTER TABLE media ADD COLUMN DeviceId integer;
15 UPDATE media SET DeviceId=0;
16 ALTER TABLE media ADD COLUMN MediaTypeId integer;
17 UPDATE media SET MediaTypeId=0;
18 ALTER TABLE media ADD COLUMN LocationId integer;
19 UPDATE media SET LocationId=0;
20 ALTER TABLE media ADD COLUMN RecycleCount integer;
21 UPDATE media SET RecycleCount=0;
22 ALTER TABLE media ADD COLUMN InitialWrite timestamp without time zone;
23 UPDATE media SET InitialWrite=0;
24 ALTER TABLE media ADD COLUMN scratchpoolid integer;
25 UPDATE media SET scratchpoolid=0;
26 ALTER TABLE media ADD COLUMN recyclepoolid integer;
27 UPDATE media SET recyclepoolid=0;
28 ALTER TABLE media ADD COLUMN enabled integer;
29 UPDATE media SET enabled=1;
31 ALTER TABLE job ADD COLUMN RealEndTime timestamp without time zone;
32 UPDATE job SET RealEndTime=0;
33 ALTER TABLE job ADD COLUMN PriorJobId integer;
34 UPDATE job SET PriorJobId=0;
36 ALTER TABLE jobmedia DROP COLUMN Stripe;
38 CREATE TABLE Location (
39 LocationId SERIAL NOT NULL,
40 Location TEXT NOT NULL,
41 Cost integer not null default 0,
42 PRIMARY KEY (LocationId)
47 JobId serial not null,
48 LogText text not null,
51 create index log_name_idx on Log (JobId);
55 INSERT INTO version (versionId) VALUES (10);
61 echo "Update of Bacula PostgreSQL tables succeeded."
63 echo "Update of Bacula PostgreSQL tables failed."