The README for the oracle_fdw clearly says: "You cannot use LDAP functionality both in PostgreSQL and in Oracle, period."
Actually this means: "DO NOT EVEN TOUCH!"
I found this out yesterday when tracking down frequent sigsevs in one of our PostgreSQL servers.
The Oracle instant client was set up with NAMES.DIRECTORY_PATH=(TNSNAMES, LDAP) in sqlnet.ora.
Even when the connect string used in the FDW is in the //<server>:<port>/<service> form, i.e. no Oracle name resolution is required, just allowing LDAP in sqlnet.ora will kill your server.
No comments:
Post a Comment