> Zitat von Doug Sampson <dougs AT dawnsign DOT com>:
> 
> >>
> >> Questions:
> >>
> >> 1) Do I actually need to remove the bacula packages?
> 
>  From Bacula point of view, no. But your package system might force
> you because of dependencies. If you compile from source it will be
> better to link Bacula against the actual used PostgreSQL libs.
> 
Okay.

> >>
> >> 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?
> 
> The "update-bacula-tables" is only needed for Bacula updates. Database
> upgrades has no need to later the data/schema used by Bacula.

Good to know I don't need to run the 'update-Bacula-tables' command.

> 
> >> 3) Is PGSQL 9.2 considered stable? 9.1 had some serious bugs but these
> >> appeared to have been squashed.
> 
> There should be no big difference because 9.2 is a minor release. In
> general PostgreSQL is one of the more reliable databases.
> 
> >> 4) Are there any special parameters I need to consider when going from
> >> PGSQL 8.3 to 9.2 especially in the postgresql.conf?
> 
> Tune for inserts:
> http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
> 

Yes, I've looked there. I didn't see anything useful that was introduced. Or am 
I terribly mistaken?

> >> 5) Any other caveats?
> 
> You might run Baculas "dbcheck" to prune unused entries in the
> database before migration.
> 

I ran:
root@pisces:/~# su -m bacula -c '/usr/local/sbin/dbcheck -B -c 
/usr/local/etc/bacula-dir.conf'
catalog=MyCatalog
db_name=bacula
db_driver=
db_user=bacula
db_password=
db_address=
db_port=0
db_socket=
db_type=PostgreSQL
working_dir=/var/db/bacula
root@pisces:/~#

It completed within seconds. Looks good, no?

> >> 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?
> 
> No, never used, but in general the PostgreSQL database and tools
> simply does what is expected, so it should just work.
> 

The fact you've not used it yourself makes me want to stick to the 
tried-and-found-true method of updating.

Thanks.

~Doug

------------------------------------------------------------------------------
Own the Future-Intel&reg; Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users