| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'Sumeet Shukla *EXTERN*'" <sumeet(dot)k(dot)shukla(at)gmail(dot)com> |
| Cc: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> |
| Subject: | Re: error installing oracle_fdw extension |
| Date: | 2017-05-22 13:12:45 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B53A4DD4A@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cachique | 2017-05-22 14:53:10 | Re: error installing oracle_fdw extension |
| Previous Message | Sumeet Shukla | 2017-05-22 09:24:00 | Re: error installing oracle_fdw extension |