On 9 Jan 2007 at 23:21, Steen Meyer wrote:

> I'm thinking of upgrading postgress at the same time as going up to Bacula 2.
> Any views on order of upgrades or any issues met?

For the PG upgrade, you need to dump and restore your db.

I think it depends upon your OS and how upgrading is handled.  If you 
were using FreeBSD, I'd do this (untested)

stop bacula
stop postgresql
backup your postgresql databases

portupgrade -Rr -o databases/postgresql-server postgresql82-server \
   -o databases/postgresql-client postgresql82-client \
    bacula-server bacula-client

move /usr/local/pgsql/data away (perhaps keeping note of any local 
configuration changes you made)

run your PG initdb
start postgresql

load your databases

run the bacula upgrade postgresql script, followed by the privileges 
script

start bacula

enjoy

:)


-- 
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php
PGCon - The PostgreSQL Conference - http://www.pgcon.org/



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to