Sumeet Shukla wrote: > Yes, postmaster does not seem to be aware of LD_LIBRARY_PATH. I tried ldconfig and > postgres service restart but it does not seem to work. How can I fix this. You first have to add a line to /etc/ld.so.conf that reads /usr/lib/oracle/12.1/client64/lib Then run "ldconfig". > Also the owner of /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1 is root. Please > confirm if it is OK. Yes, as long as the PostgreSQL user has permission to read the file. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin