Re: [Bacula-users] stuck on upgrading from 7.0.5 to 9.0.6

[Kern Sibbald]

Hello, Before using the update_postgres_tables script, the Bacula database must exist.  My best guess is that in this case the database does not exist, which is odd, because during the Bacula upgrade process, normally you have an existing database that you keep and simply upgrade. Best regards, Kern On 06/07/2018 10:52 PM, Jonathan Horne wrote: Hi all, i am stuck with a tricky migration/upgrade scenario. my source system is a CentOS 6.8 with bacula 7.0.5.  its been in production for a few years and has never given me one bit of trouble. my new server is a ubuntu 18 with bacula 9.0.6.  my intention is to take the /opt/backups file system off the old server and attach it to same mount location on new server, and hopefully pick up where the old server left off with all the existing backup media.  i have imported the database that was dumped from the old server, but i am stuck on the update_postgresql_tables script.  here is the output i get: postgres@bkp01:~$ sh /usr/share/bacula-director/update_postgresql_tables This script will update a Bacula PostgreSQL database from version 12-15 to 16 Depending on the current version of your catalog, you may have to run this script multiple times. ERROR:  relation "version" does not exist LINE 1: select VersionId from Version LIMIT 1                               ^ Unable to detect database version, you can specify connection information on the command line. Error. Cannot upgrade this database. i am not a database expert, so if someone could point me in the right direction i would appreciate the assist.  or if there is a better way to get from Cent68/bacula705 to ubuntu18/bacula906, i am making this crazy leap (from OS to OS) because newer rpms/repositories for CentOS 6 seemed to have run dry. thank you kindly, Jonathan Horne ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users