*chuckle* hey i thought you were supposed to know this stuff :-)
it does this ('service' just calls the init script... its a redhat thing i
guess):
su -l -s /bin/sh postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
now, if i do this:
su -l -s /bin/sh postgres -c "/usr/bin/postmaster -D $PGDATA"
(or something close) it works... the postmaster starts without detaching
from the terminal and then the alternate location stuff works fine.
i'm looking at pg_ctl and so far i don't see any reason why the environment
would be getting munged in there.
glen
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, November 13, 2001 03:38 PM
> To: Glen Parker
> Cc: Pg-General
> Subject: Re: [GENERAL] CREATE DATABASE WITH LOCATION
>
>
> "Glen Parker" <glenebob@nwlink.com> writes:
> >> Exactly how did you restart the postmaster?
>
> > service postgresql restart
>
> And what does that do? My bet is that when you dig into it, you'll
> find it's not supplying the environment you expect to the postmaster.
>
> regards, tom lane
>