"Glen Parker" <glenebob@nwlink.com> writes:
> having a little problem with the alternate DB location stuff, on redhat
> 7.2/postgres 7.1.3. 'CREATE DATABASE WITH LOCATION 'PGDATA2' claims that
> PGDATA2 environment not set, although i've defined it in .bash_profile (for
> user posgres) and verified that it takes when i 'su -l postgres'. yes, i
> restarted the postmaster.
Exactly how did you restart the postmaster?
Also, did you remember to "export PGDATA2" from the profile file, not
merely set its value?
regards, tom lane
