Re: tables, where

Rich Shepard <rshepard@appl-ecosys.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