[OPEN-ILS-DEV] Upgrading to pg9 (from 8.4) on Squeeze, quick how-to

[Bill Erickson]

In case others find it handy, this worked well for me:

# stop evergreen and disconnect all db clients
# Add to /etc/apt/sources.list:
  deb http://www.backports.org/debian squeeze-backports main contrib
non-free
$ apt-get update
$ pg_dump [db connect args] [db name] > evergreen-backup.sql # backup db
(optional)
$ apt-get -t squeeze-backports install postgresql-9.0 postgresql-client-9.0
postgresql-contrib-9.0 postgresql-plperl-9.0
$ pg_dropcluster --stop 9.0 main
$ pg_upgradecluster 8.4 main
# All done, test with psql
evergreen=# select version();
...
evergreen=# select count(*) from biblio.record_entry;
...
# Looks good.  Restart Evergreen/Apache
$ pg_dropcluster 8.4 main # optional

-b

-- 
Bill Erickson
| VP, Software Development & Integration
| Equinox Software, Inc. / Your Library's Guide to Open Source
| phone: 877-OPEN-ILS (673-6457)
| email: erickson at esilibrary.com
| web: http://esilibrary.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20110217/d6ddb2be/attachment.htm