Re: [ADMIN] error installing oracle_fdw extension

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: [ADMIN] error installing oracle_fdw extension
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B53A4DD4A@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: [ADMIN] error installing oracle_fdw extension  (Sumeet Shukla <sumeet.k.shukla@gmail.com>)
Ответы Re: [ADMIN] error installing oracle_fdw extension  (Cachique <cachique@gmail.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Sumeet Shukla
Дата:
Сообщение: Re: [ADMIN] error installing oracle_fdw extension
Следующее
От: Cachique
Дата:
Сообщение: Re: [ADMIN] error installing oracle_fdw extension