Re: [ADMIN] error installing oracle_fdw extension - Mailing list pgsql-admin
From | Sumeet Shukla |
---|---|
Subject | Re: [ADMIN] error installing oracle_fdw extension |
Date | |
Msg-id | CABUL135s9hOAFN+54KaWe7qYAcS+F2fA1-YbCy-pkaA5e62c5Q@mail.gmail.com Whole thread Raw |
In response to | Re: [ADMIN] error installing oracle_fdw extension (Cachique <cachique@gmail.com>) |
Responses |
Re: [ADMIN] error installing oracle_fdw extension
|
List | pgsql-admin |
Thank You All for jumping in for the help. I was able to install it finally. The problem was with the way I was restarting postgresql service.
The environment variable $LD_LIBRARY_PATH reflects if I use "/etc/init.d/postgresql-9.6 restart" command but it does not reflect if I use "service postgresql-9.6 restart".
I find it little weird since essentially both the commands are internally calling the same service file. Any insight on this would be appreciated.
Warm Regards,
Sumeet Shukla
On Mon, May 22, 2017 at 8:23 PM, Cachique <cachique@gmail.com> wrote:
Something like this...* In that file specify a section [Service] with your Oracle environment variables.* Put inside a file (name is not important) with extension .conf -> orafwd.confand name it the same as your service with suffix .d -> postgresql-9.5.service.d* You need to create a directory insideUsing this post ( https://serverfault.com/It has to do with the way systemd handles environment variables. Apparently systemd isn't aware of exports of variables. It uses a special section in a special file.Hi.I had this problem a while ago.questions/413397/how-to-set- environment-variable-in- systemd-service ) I managed to create the extension.
Steps to follow.../etc/systemd/system/
[Service]
Environment=ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
Environment=TNS_ADMIN=/u01/app/oracle/product/11.2.0/xe/ network/admin * Article says you can use systemctl edit yourservice but I didn't tried that. Just created the directory and file by myself.* Names and paths may vary according to your distribution and likes.ResumingWith content...
You have this file...
/etc/systemd/system/postgresql-9.5.service.d/ orafdw.conf
[Service]
Environment=ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
Environment=TNS_ADMIN=/u01/app/oracle/product/11.2.0/xe/ network/admin
Check.
When you run systemctl status postgres you see the config file included
[root@localhost ~]# systemctl status postgresql-9.5.service
● postgresql-9.5.service - PostgreSQL 9.5 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-9.5.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/postgresql-9.5.service.d
└─orafdw.conf
Active: active (running) since Wed 2017-05-17 12:11:49 PYT; 4 days agoRegards,WalterOn Mon, May 22, 2017 at 9:12 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote: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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
pgsql-admin by date: