Binding file execution to initialization in terminal?

Question

linux

There are several variables that need to be permanently set after Posgresql initialization:

export PATH=/usr/local/pgsql/bin;
export PGDATA=/usr/local/pgsql/data;

I added them to .profile and put them in the root directory of Posgresql .
How can I make these variables auto-assign on initialization or in other words execute this file on login (even if I'm running Postgresql from a different directory?

Answer 1

if using the bash shell , then:
for the user:

$ echo 'export PATH="$PATH:/usr/local/pgsql/bin"' >> ~/.bashrc
$ echo 'export PGDATA=/usr/local/pgsql/data' >> ~/.bashrc

or in ~/.bash_profile
if needed for the superuser (root), then put in /etc/profile:

# echo 'export PATH="$PATH:/usr/local/pgsql/bin"' >>/etc/profile
# echo 'export PGDATA=/usr/local/pgsql/data' >> /etc/profile

just don't forget to restart

Answer 2

Use the -l switch when invoking su, this emulates the user's login and use of his .profile:
su -l postrgres