You could just export the variables in .pgsql_profile in the home directory of the user running PostgreSQL (usually /var/lib/pgsql). This is what I have in there for oracle_fdw:
export PATH=$PATH:/usr/pgsql-11/bin > ORACLE_HOME=/usr/lib/oracle/12.1/client64 > export LD_LIBRARY_PATH="$ORACLE_HOME/lib" At least if you installed the RPMs from the PGDG repo, this file will be sourced by .bash_profile. On Mon, Jul 15, 2019 at 4:24 PM Patrick <[email protected]> wrote: > Hi, > > I successfully set up a pacemaker cluster serving PostgreSQL. > I now have to pass some Oracle specific environment variables (i.e. > ORACLE_HOME, TNS_ADMIN) to the PostgreSQL resource. > I tried this by editing the resource ocf script > "/usr/lib/ocf/resource.d/heartbeat/pgsql" without success. > Can someone tell me how to solve this? > > Kind regards, > Patrick > _______________________________________________ > Manage your subscription: > https://lists.clusterlabs.org/mailman/listinfo/users > > ClusterLabs home: https://www.clusterlabs.org/
_______________________________________________ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users ClusterLabs home: https://www.clusterlabs.org/
