Re: CREATE DATABASE WITH LOCATION

> > 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?

service postgresql restart

and when that didnt work

service postgresql stop
service postgresql start

and then a reboot which also didnt work

> Also, did you remember to "export PGDATA2" from the profile file, not
> merely set its value?

yep, sure did.  actually, if i specify 'PGDATA' as the location, i get the
same error.  that var is exported already in the stock .bash_profile.

glen