"Scot L. Harris" <webid@cfl.rr.com> writes:
> Which indicates to me that the PGDATA2 environment variable that is
> defined in the postgres users .bash_profile is not being picked up by
> the postmaster process.
Depends which startup script you are using. I know that up till
recently the Red Hat init script did
su -l postgres -s /bin/sh -c "pg_ctl start ..."
and because it forced /bin/sh, anything you might have put in say
~postgres/.bash_profile wouldn't get read. You can just take out
that -s switch though.
regards, tom lane