[Pkg-postgresql-public] Bug#757520: postgresql-9.4: losing the database on crossgrade

[Thorsten Glaser]

Package: postgresql-9.4
Version: 9.4~beta2-1
Severity: normal

Hi *,

I just crossgraded from i386 to x32 and can no longer access the DB:

tglase at tglase:~ $ sudo service postgresql start
Starting PostgreSQL 9.4 database server: mainThe PostgreSQL server failed to start. Please check the log output: 2014-08-08 21:10:36 GMT FATAL: incorrect checksum in control file ... failed!
 failed!

I also cannot install the i386 version of the DB server, in order
to take a dump, because the packages lack appropriate Multi-Arch
annotations:

The following packages have unmet dependencies:
 postgresql-9.4:i386 : Depends: postgresql-client-9.4:i386 but it is not going to be installed
                       Depends: postgresql-common:i386 (>= 142~) but it is not installable

Would be cool if the latter could be fixed, or if there is a
cross-CPU dumping tool for databases. (I can understand that
the DB format is CPU-dependent, even if I don’t like it, but
it’s at least not in my $HOME like the KDE Wallet I which is
also lost to the changes.)

-- System Information:
Debian Release: jessie/sid
  APT prefers unreleased
  APT policy: (500, 'unreleased'), (500, 'unstable')
Architecture: x32 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.14-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=C, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/lksh

Versions of packages postgresql-9.4 depends on:
ii  libc6                  2.19-7
ii  libgssapi-krb5-2       1.12.1+dfsg-6
ii  libldap-2.4-2          2.4.39-1
ii  libpam0g               1.1.8-3
ii  libpq5                 9.4~beta2-1
ii  libssl1.0.0            1.0.1i-1
ii  libxml2                2.9.1+dfsg1-4
ii  locales-all [locales]  2.19-7
ii  postgresql-client-9.4  9.4~beta2-1
ii  postgresql-common      159
ii  ssl-cert               1.0.34
ii  tzdata                 2014e-1

postgresql-9.4 recommends no packages.

Versions of packages postgresql-9.4 suggests:
ii  ident2 [ident-server]  1.07-1.1
ii  locales-all            2.19-7

-- no debconf information