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

[Mike Rylander]

This also works on lenny, but replace Bill's apt source with:

deb http://backports.debian.org/debian-backports lenny-backports-sloppy main

--miker

On Thu, Feb 17, 2011 at 1:06 PM, Bill Erickson <erickson at esilibrary.com> wrote:
>
> 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
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com