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:
1. Install PostgreSQL server
2. Fix some utf-8 invalid chars: iconv -c -f UTF-8 -t UTF-8 -o
/tmp/bacula_new.sql /tmp/bacula.sql
3. sh create_postgresql_database
4. psql create user bacula (needed to restore sql dump)
5. su - postgres; psql -d bacula -f /tmp/bacula_new.sql (7GB sql file)
6. sh update_postgresql_tables_12_to_14
7. sh grant_postgresql_privileges
8. Install bacula
9. Overwrite /etc/bacula with the old server's files and scripts
10. Start the daemons
11. Run a backup and restore
12. 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/ <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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
