I need to migrate Bacula from PGSQL 8.3 as it's being EOL'ed. The newest 
version of PGSQL available in the FreeBSD ports tree is 9.2. Below are the 
steps I've taken to describe the migration process:

########################################################

Backup PGSQL config file(s)
        /home/pgsql/pg_hba.conf
        /home/pgsql/postgresql.conf

Backup Bacula config file(s)
        /usr/local/etc/bacula-dir.conf
        /usr/local/etc/bacula-fd.conf
        /usr/local/etc/bacula-sd.conf
        /usr/local/etc/bconsole.conf

Dump PGSQL Bacula DB
        /usr/local/bin/pg_dump bacula -v /home/bacula.sql

Rename PG data directory
        mv /home/pgsql /home/pgsql.old

Stop PGSQL & Bacula processes
        /usr/local/etc/rc.d/z-bacula.sh stop
        /usr/local/etc/rc.d/postgresql stop

Uninstall Bacula Server & Client and any other Bacula package
        cd /usr/ports/sysutils/bacula-server && make deinstall clean
        cd /usr/ports/sysutils/bacula-client && make deinstall clean

Uninstall Postgresql 8.3 Server & Client
        cd /usr/ports/databases/postgresql83-server && make deinstall clean
        cd /usr/ports/databases/postgresql83-client && make deinstall clean

Install Postgresql 9.2
        Install /usr/ports/databases/postgresql92-server
        Install /usr/ports/databases/postgresql92-client

Initialize PGSQL db
        initdb -D /usr/local/pgsql/data
        if this gives you an error message
        stop pgsql then 'rm -rf /home/pgsql/data'
        start pgsql
        then 'initdb -D /home/pgsql/data'   - should work this time

Install Bacula
        cd /usr/ports/sysutils/bacula-server && make install clean
        cd /usr/ports/sysutils/bacula-client && make install clean

Restore PGSQL config files
        /home/pgsql/pg_hba.conf
        /home/pgsql/postgresql.conf

Restore Bacula config files
        /usr/local/etc/bacula-dir.conf
        /usr/local/etc/bacula-fd.conf
        /usr/local/etc/bacula-sd.conf
        /usr/local/etc/bconsole.conf

Configure Bacula as follows:
        make pgsql member of bacula group
        su pgsql
        /usr/local/share/bacula/create_bacula_database
        /usr/local/share/bacula/make_bacula_tables
        /usr/local/share/bacula/grant_bacula_privileges
        psql bacula < bacula.sql
                If cannot retrieve bacula.sql file for some reason, can
                restore from the most recent tape as follows:
                bextract <exact volume name of catalog> ('man bextract' for 
                more details)
        start pgsql
        start bacula
        remove pgsql as member of bacula group

Test
        start bconsole and verify status of director
        start a simple backup job and verify

########################################################


Questions:

1) Do I actually need to remove the bacula packages?

2) Are there any special steps that I'm missing when configuring the bacula 
databases? Do I need to run 'update-bacula-tables' somewhere in there?

3) Is PGSQL 9.2 considered stable? 9.1 had some serious bugs but these appeared 
to have been squashed.

4) Are there any special parameters I need to consider when going from PGSQL 
8.3 to 9.2 especially in the postgresql.conf?

5) Any other caveats?

6) pg_upgrade: I came across this new function. Apparently you can upgrade 
databases from 8.3.x to 9.2.x with some caveats as described in the " 
Limitations in Upgrading from PostgreSQL 8.3" section of this link 
http://www.postgresql.org/docs/9.2/static/pgupgrade.html. If you've used this, 
would you care to share your experiences?


Thanks in advance.

~Doug

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users