0

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?

  • Is your system multiarch already? Did you run dpkg --add-architecture i386; apt-get update before attempting having both libraries installed at the same time? – Ziggy Crueltyfree Zeitgeister Apr 12 '16 at 7:40
  • @ZiggyCrueltyfreeZeitgeister I already did that for the requirements for other i386 software. I run the apt-get installl postgresql-client:i386 and it installed without appearing the x86_64 libraries, but I suspect some of the other utilities will be affected, but I will only find out when I try to run them. – vfclists Apr 12 '16 at 11:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.