[Pkg-postgresql-private] Re: Bug#225635: postgresql: manual upgrade of database fails

[Oliver Elphick]

On Wed, 2003-12-31 at 04:53, Chris Hanson wrote:
> Package: postgresql
> Version: 7.4.1-1
> Severity: important
> 
> Attempting to upgrade the database after upgrading to the new version
> fails, because of a missing shared library.  The library doesn't seem
> to be available in the Debian archive.
> 
> postgres@kleph:~$ postgresql-dump -t /data/tmp/pg-backup
> /var/lib/postgres/dumpall/7.3/postmaster -D /var/lib/postgres/data  -p 5431 -o -d0
> /var/lib/postgres/dumpall/7.3/postmaster: error while loading shared libraries: libcom_err.so.1: cannot open shared object file: No such file or directory
> Failed to start the postmaster

> Versions of packages postgresql depends on:
...
> ii  libcomerr2    1.34+1.35-WIP-2003.12.07-2 The Common Error Description libra
> ii  libkrb53      1.3-2                      MIT Kerberos runtime libraries

Oh dear; that is definitely tricky:
$ dlocate libcom_err.so
comerr-dev: /usr/lib/libcom_err.so
libcomerr2: /lib/libcom_err.so.2.1
libcomerr2: /lib/libcom_err.so.2
libcomerr1-kerberos4kth: /usr/lib/libcom_err.so.1.1.1
libcomerr1-kerberos4kth: /usr/lib/libcom_err.so.1

So libcom_err.so.1 is provided by a dependency of the old package, which
has already gone.  The solution should be to copy that library into the
dumpall backup store, but the instructions to do that need to be in the
_old_ package's prerm.

So this isn't readily soluble.  The problem will go away when I complete
the new structure that will allow different versions of postgresql to
co-exist.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Ye have heard that it hath been said, Thou shalt love 
      thy neighbour, and hate thine enemy. But I say unto 
      you, Love your enemies, bless them that curse you, do 
      good to them that hate you, and pray for them which 
      despitefully use you, and persecute you;"          
                                     Matthew 5:43,44