Trying to figure out shell environment differences between the service script & postgres shell, if I comment out the following variable in profile file/add them after performing initdb operation, the postgresql operations seem to work fine -
PATH=$PATH:/usr/pgsql-9.2/bin
export PATH
export POSTGRESQL_JDBC_DRIVER=/opt/lib/postgresql-9.2-1003.jdbc4.jar
export PG_HOME=/var/lib/pgsql/data/
These variables are needed by a few cron scripts that would be installed later on after my postgres config completes successfully.
The yum postgresql link I used earlier to download the RPM dos not the debuginfo package for 9.2.4 version. Will it be OK to use the latest debuginfo package with the rest being on version 9.2.4? Or I will have to use all the latest RPM packages?
Thanks
Bhushan Pathak