Some time ago I had a problem running with a conflict between the 32bit and 64 bit clients on PostgreSQL which I described here Is my system configuration restricting me to psql:i386?. I have come to the same stage again on another system. Trying to install the i386 client threatens to replace the original client.
root@server:/usr/src/packages# apt-get -s install postgresql-client:i386 Reading package lists... Done Building dependency tree Reading state information... Done Package postgresql-client:i386 is a virtual package provided by: postgresql-client-9.5:i386 9.5.2-1.pgdg80+1 postgresql-client-9.4:i386 9.4.7-1.pgdg80+1 postgresql-client-9.3:i386 9.3.12-1.pgdg80+1 postgresql-client-9.2:i386 9.2.16-1.pgdg80+1 postgresql-client-9.1:i386 9.1.21-1.pgdg80+1 postgresql-client-9.0:i386 9.0.22-1.pgdg80+1 postgresql-client-8.4:i386 8.4.22-1.pgdg+2 postgresql-client-9.5 9.5.2-1.pgdg80+1 postgresql-client-9.4 9.4.7-1.pgdg80+1 postgresql-client 9.5+173.pgdg80+1 You should explicitly select one to install. E: Package 'postgresql-client:i386' has no installation candidate root@server:/usr/src/packages#
The intended action of
apt-get install postgresql-client:i386:
root@server:/usr/src/packages# apt-get install postgresql-client-9.5:i386 Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: gir1.2-freedesktop gir1.2-pango-1.0 libossp-uuid16 libpangoxft-1.0-0 Use 'apt-get autoremove' to remove them. The following extra packages will be installed: libdb5.3:i386 libldap-2.4-2 libldap-2.4-2:i386 libpq5:i386 libsasl2-2:i386 libsasl2-modules:i386 libsasl2-modules-db:i386 libssl1.0.0:i386 Suggested packages: libsasl2-modules-otp:i386 libsasl2-modules-ldap:i386 libsasl2-modules-sql:i386 libsasl2-modules-gssapi-mit:i386 libsasl2-modules-gssapi-heimdal:i386 postgresql-9.5:i386 postgresql-doc-9.5:i386 The following packages will be REMOVED: postgresql-client-9.5 The following NEW packages will be installed: libdb5.3:i386 libldap-2.4-2:i386 libpq5:i386 libsasl2-2:i386 libsasl2-modules:i386 libsasl2-modules-db:i386 libssl1.0.0:i386 postgresql-client-9.5:i386 The following packages will be upgraded: libldap-2.4-2 1 upgraded, 8 newly installed, 1 to remove and 219 not upgraded. Need to get 4,886 kB of archives. After this operation, 11.2 MB of additional disk space will be used. Do you want to continue? [Y/n]
As seen installing the i386 version will remove the x86_64 version which caused the previous problem.
Is there some way to have both? My idea is to download the .deb package of the i386 client and extract the files I need into the i386 library directories. Will that be a good idea?