[Pkg-postgresql-public] postgresql multiarch problems

[Alexander Bürger]

Hi Christoph!

>> … need to run i386 postgresql-9.2 on a amd64 machine …
>> Installing postgresql-9.2:i386 fails because it depends on postgresql-common
>> and postgresql-client-common. aptitude, apt-get, and dpkg all claim that
>> postgresql-(client-)common are not available for i386 even though the
>> package is architecture-independent. I do not understand this. All other
>> i386 dependencies can be installed easily.

> … need to have an explicit "Multi-Arch: foreign" …

Ok, I was not aware of that. Why is it not there?

> What does "apt-cache policy postgresql-9.2 postgresql-common
> postgresql-client-common" output for you?

$ apt-cache policy postgresql-9.3 postgresql-9.2 postgresql-common
postgresql-9.3:
  Installed: 9.3.5-1.pgdg14.04+1
  Candidate: 9.3.5-1.pgdg14.04+1
  Version table:
 *** 9.3.5-1.pgdg14.04+1 0
        500 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main amd64 Packages
        100 /var/lib/dpkg/status
     9.3.5-0ubuntu0.14.04.1 0
        500 ftp://ftp.stratoserver.net/pub/linux/ubuntu/ trusty-updates/main amd64 Packages
     9.3.4-1 0
        500 ftp://ftp.stratoserver.net/pub/linux/ubuntu/ trusty/main amd64 Packages
postgresql-9.2:
  Installed: (none)
  Candidate: 9.2.9-1.pgdg14.04+1
  Version table:
     9.2.9-1.pgdg14.04+1 0
        500 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main amd64 Packages
postgresql-common:
  Installed: 154.pgdg14.04+1
  Candidate: 154.pgdg14.04+1
  Version table:
 *** 154.pgdg14.04+1 0
        500 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main amd64 Packages
        100 /var/lib/dpkg/status
     154 0
        500 ftp://ftp.stratoserver.net/pub/linux/ubuntu/ trusty/main amd64 Packages

I installed postgresql-9.2 i386 packages, dumped the database, removed i386, installed postgesql-9.3 amd64, and restored from the dump. Worked fine.

Alexander