Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

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/local/bin:/bin:/usr/bin:/usr/local/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/bin/edb-postgres -D /opt/PostgresPlus/9.2AS/data
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/bin/pgagent -l 1 -s /var/log/ppas-agent-9.2.log 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/bin/pgbouncer -d /opt/PostgresPlus/9.2AS/share/pgbouncer.ini
postgres 13629     1  0 01:05 ?        00:00:05 /opt/PostgresPlus/9.2AS/jre/bin/java -XX:-UsePerfData -Xms64m -Xmx256m -Djava.library.path=/opt/PostgresPlus/9.2AS/bin -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/jre/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/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/usr/bin:/bin:/root/bin
ASKER CERTIFIED SOLUTION
Avatar of earth man2
earth man2
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial