On Tue, May 21, 2013 at 8:40 PM, Dann Corbit <dcor...@connx.com> wrote:
> >> > > I guess that if you did a successful make install of unixODBC-2.3.0 it > will work as your ODBC driver manager. > > On the other hand, it is easier and more trouble free to use the > standardized package installer for your distribution. > > << > Yes unixODBC-2.3.0 successfully installed. On Tue, May 21, 2013 at 9:02 PM, John R Pierce <pie...@hogranch.com> wrote: > I have no idea what you're saying here. what 1st package? you should > apply all pending updates to your operating system as a matter of good > practice. if this is a production system, you should of course, test the > updates on a staging server before updating production. > Yes, actually package update started but need to get this done on stage server first for existing packages. I meant if unixODBC-libs is not present on this system then update for it will not be patched. > again, simply... > > yum install unixODBC-libs > > that should install the ODBC runtime libraries that the postgres driver > requires. if it doesn't then you don't have access to the RHEL > repositories, which suggests you're either not a subscriber, or you haven't > properly registered this system via your Red Hat Network account. If this > system doesn't have a paid Red Hat Enterprise Linux support contract, then > you really shouldn't BE running Red Hat Enterprise Linux as you can't > install anything, can't get security updates, or anything. CentOS 5 or 6 > are compatible rebuilds with free public repositories. Need to check this tomorrow regarding registration. BTW where does the 'postgresql91-odbc.x86_64' looking for libodbc.so.1 and libodbcinst.so.1 files. unixODBC-2.3.0 was successfully installed and both these libraries are under /usr/local/lib/. # ldd libodbc.so.1 libdl.so.2 => /lib64/libdl.so.2 (0x00002b3fb5661000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b3fb5865000) libc.so.6 => /lib64/libc.so.6 (0x00002b3fb5a80000) /lib64/ld-linux-x86-64.so.2 (0x0000003164800000) Also tried to export PATH and LD_LIBRARY_PATH and then ran 'yum install postgresql91-odbc' but still facing same errors: Error: Missing Dependency: libodbc.so.1()(64bit) is needed by package postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) Error: Missing Dependency: libodbcinst.so.1()(64bit) is needed by package postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) Any particular location or is it like unixODBC-2.3.0 installation is not enough to bless 'postgresql91-odbc.x86_64' package installation. Regards...