Re: Multiple databases on seperate drives/file systems?

On Wed, 2004-06-09 at 10:20, Tom Lane wrote:
> 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

Thanks for the pointer.

The startup script in /etc/init.d does have the su line as you describe
above. On RH8 it appears that /bin/sh is linked to /bin/bash. So does
the shell being executed not look at the .bash_profile since it was
invoked as /bin/sh?

Or can I just put the PGDATA2 environment variable in a .profile file?

--
Scot L. Harris <webid(at)cfl(dot)rr(dot)com>