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