Public bug reported: On amd64 certain 32 bit applications need 32 bit ODBC. An example is wine.
Currently odbc-postgresql:i386 depends on libpq5:i386. However, other 64bit packages depend on libpq5 (amd64) like pgadmin, libreoffice-sdbc-postgresql. Both can't be installed at the same time. Probably libpq.so should be installed to /usr/lib/i386-linux-gnu/ to install simultaneous installation. A workaround is to manually download odbc-postgresql:i386 and libpq5:i386. Then unpack so's to /usr/lib/i386-linux-gnu/odbc and libpq5:i386 to /usr/lib/i386-linux-gnu. Then modify odbcinst.ini to look like this: [PostgreSQL Unicode] Description = PostgreSQL ODBC driver (Unicode version) Driver = /usr/lib/i386-linux-gnu/odbc/psqlodbcw.so Driver64 = psqlodbcw.so Setup = /usr/lib/i386-linux-gnu/odbc/libodbcpsqlS.so Setup64 = libodbcpsqlS.so UsageCount = 1 CPTimeout = CPTimeToLive = DisableGetFunctions = DontDLCLose = ExFetchMapping = Threading = FakeUnicode = IconvEncoding = Trace = TraceFile = TraceLibrary = Debug = 0 CommLog = 1 [PostgreSQL ANSI] Description = PostgreSQL ODBC driver (ANSI version) Driver = /usr/lib/i386-linux-gnu/odbc/psqlodbca.so Driver64 = psqlodbca.so Setup = /usr/lib/i386-linux-gnu/odbc/libodbcpsqlS.so Setup64 = libodbcpsqlS.so UsageCount = 1 CPTimeout = CPTimeToLive = DisableGetFunctions = DontDLCLose = ExFetchMapping = Threading = FakeUnicode = IconvEncoding = Trace = TraceFile = TraceLibrary = Debug = 0 CommLog = 1 Now wine, pgadmin, libreoffice will be able to coexist and run at the same time. Ferry ** Affects: postgresql-9.1 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1081517 Title: i386 libpq5 conflict on amd64 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/1081517/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs