Bacula 13.0.4 Upgrade with Existing PostgreSQL Database - Version Error

Hello community,

I'm upgrading my Bacula Director from 9.4.2 to 13.0.4 on Ubuntu 24.04. My
PostgreSQL database (version 12) is located on a separate server (Ubuntu
20.04). This PostgreSQL server hosts two Bacula catalog databases:

    bacula_prod: My production 9.4.2 catalog (which I want to keep as is).

    bacula_dev: A new database created for the 13.0.4 upgrade.

My goal was to create a new database for the Bacula 13.0.4 installation,
leaving my existing 9.4.2 setup untouched. I performed the following steps:

    Dumped the bacula_prod database (from the 9.4.2 setup).

    Restored the dump into a new database named bacula_dev on the
PostgreSQL server.

    Installed Bacula 13.0.4 on my Ubuntu 24.04 server.

    Configured the 13.0.4 Director to connect to the bacula_dev database.

However, when I try to start the Bacula 13.0.4 Director, I encounter the
following error:

May 19 16:27:22 HOSTNAME.DOMAIN.com bacula-dir[883320]: bacula-dir:
dird.c:1462-0 Could not open Catalog "BackupCatalog", database "bacula_dev".
May 19 16:27:22 HOSTNAME.DOMAIN.com bacula-dir[883320]: bacula-dir:
dird.c:1468-0 Version error for database "bacula_dev". Wanted 1024, got 16
May 19 16:27:22 HOSTNAME.DOMAIN.com bacula-dir[883320]: 19-May 16:27
bacula-dir ERROR TERMINATION

It seems that the Bacula 13.0.4 Director is expecting a database schema
version 1024, but it's finding version 16 (the version from my Bacula 9.4.2
database dump).

My understanding is that I need to upgrade the schema of the bacula_dev
database to be compatible with Bacula 13.0.4. I believe I need to use the
update_bacula_tables script, but I want to confirm the correct procedure to
avoid affecting my production bacula database.

Could you please advise on the correct way to upgrade the bacula_dev
database schema in this situation?  Specifically:

    What is the exact command I should use with update_bacula_tables to
target the bacula_dev database?

    Are there any specific precautions I should take, given that I have
another Bacula database on the same PostgreSQL server?

Any help would be greatly appreciated.

Thank you.

Sincerely,
Saif

_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users