Rich Shepard <rshepard(at)appl-ecosys(dot)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