Re: CREATE DATABASE WITH LOCATION

*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(at)sss(dot)pgh(dot)pa(dot)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(at)nwlink(dot)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
>