There were several bug reports filed in the bugs database concerning the PostgreSQL scripts. Since the bug reports came with patches or solutions, I didn't release patches for this, so I suggest you take a look there. Otherwise, you can obtain corrected files from the CVS. They will also be distributed with 1.38.1 in the near future.
On Saturday 12 November 2005 03:55, [EMAIL PROTECTED] wrote: > 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 -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- 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
