I got the following errors when I upgraded my bacula database to version 9 using the update_postgresql_tables script. I was running bacula version 1.36.3 before the bacula upgrade and now I am at 1.38.0. My database is postgresql 7 or possibly postgresql 8. I just wanted to know if this is anything to worry about..
ALTER TABLE UPDATE 33 ALTER TABLE ALTER TABLE UPDATE 33 ALTER TABLE UPDATE 9 ALTER TABLE ALTER TABLE psql:<stdin>:12: ERROR: syntax error at or near "NextPoolId" at character 22 psql:<stdin>:12: LINE 1: ALTER TABLE pool SET NextPoolId=0; psql:<stdin>:12: ^ ALTER TABLE psql:<stdin>:14: ERROR: syntax error at or near "MigrationHighBytes" at character 22 psql:<stdin>:14: LINE 1: ALTER TABLE pool SET MigrationHighBytes=0; psql:<stdin>:14: ^ ALTER TABLE psql:<stdin>:16: ERROR: syntax error at or near "MigrationLowBytes" at character 22 psql:<stdin>:16: LINE 1: ALTER TABLE pool SET MigrationLowBytes=0; psql:<stdin>:16: ^ ALTER TABLE psql:<stdin>:18: ERROR: syntax error at or near "MigrationTime" at character 22 psql:<stdin>:18: LINE 1: ALTER TABLE pool SET MigrationTime=0; psql:<stdin>:18: ^ ALTER TABLE UPDATE 867 ALTER TABLE UPDATE 867 ALTER TABLE UPDATE 33 ALTER TABLE psql:<stdin>:36: NOTICE: CREATE TABLE will create implicit sequence "mediatype_mediatypeid_seq" for "serial" column "mediatype.mediatypeid" psql:<stdin>:36: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "mediatype_pkey" for table "mediatype" CREATE TABLE psql:<stdin>:55: ERROR: syntax error at or near "UNSIGNED" at character 120 psql:<stdin>:55: LINE 5: StorageId INTEGER UNSIGNED, psql:<stdin>:55: ^ psql:<stdin>:62: NOTICE: CREATE TABLE will create implicit sequence "storage_storageid_seq" for "serial" column "storage.storageid" psql:<stdin>:62: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "storage_pkey" for table "storage" CREATE TABLE psql:<stdin>:68: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "status_pkey" for table "status" CREATE TABLE INSERT 23531317 1 INSERT 23531318 1 INSERT 23531319 1 INSERT 23531320 1 INSERT 23531321 1 INSERT 23531322 1 INSERT 23531323 1 INSERT 23531324 1 INSERT 23531325 1 INSERT 23531326 1 INSERT 23531327 1 INSERT 23531328 1 INSERT 23531329 1 INSERT 23531330 1 INSERT 23531331 1 INSERT 23531332 1 INSERT 23531333 1 INSERT 23531334 1 INSERT 23531335 1 DELETE 1 INSERT 23531336 1 VACUUM Update of Bacula PostgreSQL tables succeeded. Thanks, John M. Drescher ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
