[ClusterLabs] Add Resource Environment Variables

Tiemen Ruiten t.ruiten at tech-lab.io
Mon Jul 15 10:53:47 EDT 2019

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

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 <clusterlabs at localhorst.es> 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20190715/f5356b8d/attachment.html>

More information about the Users mailing list