Hello Yateen, You should use the "postgres" user to run the update_postgresql_tables script.
As you have installed Bacula 13 from scratch in the new server, please remember to drop the bacula database created in a fresh install before importing the current DB using dump. Then, you run the update_postgresql_tables script. Best, Ana On Tue, Jan 31, 2023 at 6:28 AM Yateen Shaligram Bhagat (Nokia) < yateen.shaligram_bha...@nokia.com> wrote: > Hello Ana, > > Thanks for your reply. > > Here is what I did... > > 1. Target for Bacula 13 upgrade is Ubuntu 22.4. > 1. Installed postgresql 14 on Ubuntu 22.4 > 2. Installed Bacula 13 using Deb package (dpkg command) > 3. Dumped Bacula database from 9.4 installation (on CentOS 6) > 4. Imported Bacula db dump into postgresql 14 on Ubuntu > 5. Tried to start Bacula 13 director. > 6. Got error message : Current Catalog version is 16, required version > 1024. > > Plz let me know the username through which i should run the > upadate_postgresql_tables > script, is it postgres user? > > Regards, > > Yateen > > > > Get Outlook for Android <https://aka.ms/AAb9ysg> > > ------------------------------ > *From:* Ana Emília M. Arruda <emiliaarr...@gmail.com> > *Sent:* Monday, 30 January, 2023, 23:27 > *To:* Yateen Shaligram Bhagat (Nokia) <yateen.shaligram_bha...@nokia.com> > *Cc:* bacula-users@lists.sourceforge.net < > bacula-users@lists.sourceforge.net> > *Subject:* Re: [Bacula-users] Bacula upgrade > > Hello Yateen, > > Have you already performed the upgrade? Have you checked if the Catalog > version has been updated? > Can you please let us know which platform you are using? > I've checked the update_postgresql_tables script and it includes the > upgrade from version 12-16 or 1014-1022 to 1024. > Are you using packages or compiling from source code? > > Best, > Ana > > On Mon, Jan 30, 2023 at 1:27 PM Yateen Shaligram Bhagat (Nokia) < > yateen.shaligram_bha...@nokia.com> wrote: > >> Hi all, >> >> >> >> Is it possible to upgrade bacula version 9.4 (catalog database version >> 16) to version 13 (catalog database version 1024) directly as one step or >> any intermediate step upgrades are required? >> >> >> >> I tried the direct upgrade, but there is no update_postgresql_tables >> script for database version 16 to 1024. >> >> >> >> Please advise. >> >> >> >> Thanks >> >> Yateen S Bhagat >> _______________________________________________ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users >> > >
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users