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

[Christoph Berg]

Re: Thorsten Glaser 2014-08-08 <20140808211219.3950.79805.reportbug at tglase.lan.tarent.de>
> 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.

Hi Thorsten,

it took me some time to make sense of this report. You'd tend to
include all sorts of context in your bug reports which you use to bury
the actual request - just putting "please M-A pg-common" in the
subject would have helped a lot. Context is nice to have in bug
reports, but please make it sound like context, not like the problem.

Anyway, I used the opportunity to dig through
https://wiki.ubuntu.com/MultiarchSpec again, and I believe I found a
set of packages that we can mark "Multi-Arch: foreign" without
breaking anything. There's even a picture about it:

https://alioth.debian.org/scm/loggerhead/pkg-postgresql/postgresql-common/trunk/download/head:/dependencies.png-20140810210718-qrxnqfvfo0ha0zcu-3/dependencies.png

Martin, could you check if that makes sense?

I thought about "Multi-Arch: allowed" for "postgresql", but refrained
because I didn't want to invoke too much magic at once.

Christoph
-- 
cb at df7cb.de | http://www.df7cb.de/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: Digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20140810/8184cb0b/attachment.sig>