The pgsql resource agent uses /bin/sh. I think it doesn't work because on RH/CentOS, /bin/sh is linked to bash, whereas on Ubuntu it's linked to dash, which doesn't source .bash_profile (which in turn sources .pgsql_profile on my system). You could try putting it in .profile? I don't currently have access to an Ubuntu system to confirm this though.
On Mon, Jul 15, 2019 at 6:51 PM Patrick <[email protected]> wrote: > Hi Tiemen, > > thank you for your fast response. > At the moment using .pgsql_profile seems not working for me. > Can you confirm that I should see the ORACLE_HOME env by grepping > /proc/$pid_of_postmaster/environ? If I run 'pg_ctl -D /pgdata start' I can > see the variable there. If I let Pacemaker > start the resource, ORACLE_HOME is not present, when I grep under > /proc/****/environ. > > PostgreSQL is compiled from source and is running on Ubuntu 18.04. > > On Jul 15, 2019 4:53:47 PM, Tiemen Ruiten wrote: > > 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/ > > >
_______________________________________________ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users ClusterLabs home: https://www.clusterlabs.org/
