upgrading postgres
Chris Turner
c.turner at 199technologies.org
Mon Apr 19 11:18:50 PDT 2010
Pierre Abbat wrote:
I meant *on DragonFly*. I don't think I have anything installed that depends
on Postgres, but I am going to install the PHP module.
Same applies - but with the additional step of managing packages..
1) Backup & Dump databases w/old pg tools (e.g. separate copy of all db
data, and an export - make sure you get the 'global' data - this
is in pg docs I believe)
2) Make sure you have old pg binary packages around - otherwise,
generate some from live system w/'pkg_tarup', download, whatever
3) delete old pkgs w/pkg_delete
4) install new packages however (binary or build)
5) recreate db data dir (e.g. w/initdb)
6) import data using tools, global first, then db's (this depends on how
you dumped them)
sorry this isn't exact steps.. but it should be good as a guide..
I hope
More information about the Users
mailing list