motioneye
asked on
PostgreSQL - Set path not working
I have just installed PostgreSQL enterprise DB.. The installation I assumed completed successfully. I open terminal then trying to set path for user postgres but it seems it does not reflected with command given.
-bash-4.1$ export PGDATA=/opt/PostgresPlus/9 .2AS/data
-bash-4.1$ echo $PATH
/usr/lib/qt-3.3/bin:/usr/l ocal/bin:/ bin:/usr/b in:/usr/lo cal/sbin:/ usr/sbin:/ sbin
-bash-4.1$
-bash-4.1$
-bash-4.1$
-bash-4.1$ exit
logout
[root@redhatTest ppasmeta-9.2.1.3-linux]#
[root@redhatTest ppasmeta-9.2.1.3-linux]# ps -ef | grep postgres
postgres 10734 1 0 00:52 ? 00:00:00 /opt/PostgresPlus/9.2AS/bi n/edb-post gres -D /opt/PostgresPlus/9.2AS/da ta
postgres 10735 10734 0 00:52 ? 00:00:00 postgres: logger process
postgres 10737 10734 0 00:52 ? 00:00:00 postgres: checkpointer process
postgres 10738 10734 0 00:52 ? 00:00:00 postgres: writer process
postgres 10739 10734 0 00:52 ? 00:00:00 postgres: wal writer process
postgres 10740 10734 0 00:52 ? 00:00:00 postgres: autovacuum launcher process
postgres 10741 10734 0 00:52 ? 00:00:00 postgres: stats collector process
postgres 10883 1 0 00:52 ? 00:00:00 /opt/PostgresPlus/9.2AS/bi n/pgagent -l 1 -s /var/log/ppas-agent-9.2.lo g hostaddr=localhost port=5432 dbname=postgres user=postgres
postgres 10884 10734 0 00:52 ? 00:00:00 postgres: postgres postgres ::1[40404] idle
postgres 12028 1 0 00:54 ? 00:00:00 /opt/PostgresPlus/9.2AS/bi n/pgbounce r -d /opt/PostgresPlus/9.2AS/sh are/pgboun cer.ini
postgres 13629 1 0 01:05 ? 00:00:05 /opt/PostgresPlus/9.2AS/jr e/bin/java -XX:-UsePerfData -Xms64m -Xmx256m -Djava.library.path=/opt/P ostgresPlu s/9.2AS/bi n -Djava.awt.headless=true -jar edb-repserver.jar pubserver 9051
postgres 13667 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35644] idle
postgres 13668 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35645] idle
postgres 13687 1 0 01:05 ? 00:00:05 /opt/PostgresPlus/9.2AS/jr e/bin/java -XX:-UsePerfData -Djava.awt.headless=true -jar edb-repserver.jar subserver 9052
postgres 13723 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35650] idle
postgres 13724 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35651] idle
root 13981 8548 0 01:16 pts/0 00:00:00 grep postgres
[root@redhatTest ppasmeta-9.2.1.3-linux]# export PGDATA=/opt/PostgresPlus/9 .2AS/data
[root@redhatTest ppasmeta-9.2.1.3-linux]# echo $PATH
/usr/lib/qt-3.3/bin:/usr/l ocal/sbin: /usr/sbin: /sbin:/usr /local/bin :/usr/bin: /bin:/root /bin
-bash-4.1$ export PGDATA=/opt/PostgresPlus/9
-bash-4.1$ echo $PATH
/usr/lib/qt-3.3/bin:/usr/l
-bash-4.1$
-bash-4.1$
-bash-4.1$
-bash-4.1$ exit
logout
[root@redhatTest ppasmeta-9.2.1.3-linux]#
[root@redhatTest ppasmeta-9.2.1.3-linux]# ps -ef | grep postgres
postgres 10734 1 0 00:52 ? 00:00:00 /opt/PostgresPlus/9.2AS/bi
postgres 10735 10734 0 00:52 ? 00:00:00 postgres: logger process
postgres 10737 10734 0 00:52 ? 00:00:00 postgres: checkpointer process
postgres 10738 10734 0 00:52 ? 00:00:00 postgres: writer process
postgres 10739 10734 0 00:52 ? 00:00:00 postgres: wal writer process
postgres 10740 10734 0 00:52 ? 00:00:00 postgres: autovacuum launcher process
postgres 10741 10734 0 00:52 ? 00:00:00 postgres: stats collector process
postgres 10883 1 0 00:52 ? 00:00:00 /opt/PostgresPlus/9.2AS/bi
postgres 10884 10734 0 00:52 ? 00:00:00 postgres: postgres postgres ::1[40404] idle
postgres 12028 1 0 00:54 ? 00:00:00 /opt/PostgresPlus/9.2AS/bi
postgres 13629 1 0 01:05 ? 00:00:05 /opt/PostgresPlus/9.2AS/jr
postgres 13667 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35644] idle
postgres 13668 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35645] idle
postgres 13687 1 0 01:05 ? 00:00:05 /opt/PostgresPlus/9.2AS/jr
postgres 13723 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35650] idle
postgres 13724 10734 0 01:05 ? 00:00:00 postgres: postgres xdb 127.0.0.1[35651] idle
root 13981 8548 0 01:16 pts/0 00:00:00 grep postgres
[root@redhatTest ppasmeta-9.2.1.3-linux]# export PGDATA=/opt/PostgresPlus/9
[root@redhatTest ppasmeta-9.2.1.3-linux]# echo $PATH
/usr/lib/qt-3.3/bin:/usr/l
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.