[Bacula-users] Advice upgrading bacula 5.0 -> 5.2

Greetings,

I have this Ubuntu 10.04 LTS server running bacula 5.0 over PostgreSQL 8.4. This server has already been upgraded from an old 3.x install, have gone trough a mysql->postgresql migration, and now is time to move ahead again. :) It may be running for almost a decade now!

I'd like to describe planned steps and have tips, considerations and advices for this process. I'm mainly worried about:

Database upgrade from version 12 -> 14;
Bacula director config changes.

I have the daily bacula.sql from the catalog backup job ("select VersionId from Version" gives 12) and a new 12.04 LTS server with bacula 5.2 and PostgreSQL 9.1 on its repos. In short detail, the planned steps are:

Install PostgreSQL server
Fix some utf-8 invalid chars: iconv -c -f UTF-8 -t UTF-8 -o /tmp/bacula_new.sql /tmp/bacula.sql
sh create_postgresql_database
psql create user bacula (needed to restore sql dump)
su - postgres; psql -d bacula -f /tmp/bacula_new.sql (7GB sql file)
sh update_postgresql_tables_12_to_14
sh grant_postgresql_privileges
Install bacula
Overwrite /etc/bacula with the old server's files and scripts
Start the daemons
Run a backup and restore
Have a beer.

I got those shell scripts from bacula source, just had to edit user, password and database name on them. I could not find any specific instructions, release notes, etc on what care should be taken regarding config files or other specifics for this process. Anything I should be aware of or the steps above should do?

Thanks and best regards.

Marcio Merlone
TI - Administrador de redes

A1 Engenharia - Unidade Corporativa

Fone:	+55 41 3616-3797
Cel:	+55 41 9689-0036

http://www.a1.ind.br/

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users