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

[Dan Scott]

On 17 February 2011 13:06, 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
>

Thanks Bill. Are there any assumptions about LANG env settings during
the install / upgrade process to ensure LC_COLLATE is set
appropriately, or does pg_upgradecluster just use whatever is in the
existing 8.4 instance?