Re: Alternate database locations

Rich Shepard <rshepard@appl-ecosys.com> writes:
>   Next I changed the environment variable, PGDATA2, to
> /opt/paisley/acctdata/ in postgres's and my ~/.bash_profile, restarted the
> postmaster and got the same error message: createdb failed because the
> postmaster doesn't understand PGDATA2.

Simply changing your .profile doesn't change the environment of your
running shell.  Did you log out/back in?  Or manually do
export PGDATA2=xxx
?

            regards, tom lane