If you installed into /usr/local/pgsql or some
other location that is not searched for programs by default, you need
to add /usr/local/pgsql/bin (or what you set --bindir to in the section called Step 2: Configure the Source Tree) to your PATH. To do this, add the following to your shell start-up file,
such as ~/.bash_profile (or /etc/profile, if you want it to affect every user):
PATH=$PATH:/usr/local/pgsql/bin |
If you are using csh or tcsh, use this command:
set path = ( /usr/local/pgsql/bin path ) |
To enable your system to find the man
documentation, you need to add a line like the following to a shell
start-up file:
MANPATH=$MANPATH:/usr/local/pgsql/man |
The environment variables PGHOST and PGPORT specify to client applications the host and port of the database
server, overriding the compiled-in defaults. If you are going to run
client applications remotely, it is convenient to have every user who
plans to use the database set PGHOST. However, this is
not required and the settings can be communicated via command line options
to most client programs.