How can I make my environment know where the psql command is without typing in that long path. Here is a few quick items to do just that.
Depending on what your default shell is for the pmx user you will want to edit the file .pmx_sh_vars or .pmx_csh_vars , just follow the same syntax inside the file. The example below is for the .pmx_sh_vars file.
Add /opt/pmx/postgres/bin to the PATH line ie.
PATH="/opt/pmx/bin:/opt/pmx/etc/init.d:/opt/pmx/postgres/bin:$PATH"
Remember to put the correct location to the postgres bin directory if you are not using the default installation directory. Next is to add the following lines
PGDATABASE=pmx_quarantine
PGDATA=/opt/pmx/postgres/var/data
PGUSER=pmx
These can go anywhere in the file as long as they are before the EXPORT line, just remember to edit the EXPORT line and add those variable names to it. ie.
export MANPATH PATH LD_LIBRARY_PATH PGDATABASE PGDATA PGUSER ...etc...
-Jason
This thread was automatically locked due to age.