Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:
> For example, (and this is what I tried with the 6.5.x series), in
> ~/.bash_profile I have this:
> PGLIB=/usr/lib/pgsql
> PGDATA=/var/lib/pgsql
> PGDATA2=/home/rshepard/accounting/paisley
> export PGLIB PGDATA PGDATA2
If this is in *your* .bash_profile then it's the wrong thing. The
environment variables must be set in the *postmaster*'s environment.
The 7.1 documentation for alternative locations is perhaps better than
what we used to have:
http://www.postgresql.org/devel-corner/docs/postgres/managing-databases.html
regards, tom lane