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

[Bill Erickson]

On Thu, Feb 17, 2011 at 1:47 PM, Dan Scott <dan at coffeecode.net> wrote:

> 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?
>

I assumed pg_upgradecluster just used whatever was in the 8.4 instance, but
I don't really know for sure.  Anything I could check in my DB to verify?

-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/4f4f140a/attachment.htm