Re: CREATE DATABASE WITH LOCATION

"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