On 1999-11-27, Rich Shepard mentioned:
> On Sat, 27 Nov 1999, Lamar Owen wrote:
>
> > Who owns '/home/rshepard/accounting/paisley', rshepard or postgres? The
> > postgres user needs to own both PGDATA and PGDATA2. Also, to call up
> > the envvar in the shell like this, you need to call it as $PGDATA or
> > ${PGDATA}.
>
> It's embarrassing to appear so dense, but it's still not working for me. I
> understand that it's a matter of owership and modes for the directories.
> Anyway, I've given up on the alternative location: I'll just build by
> accounting software in /var/lib/pgsql.
Maybe it makes you feel better, but I have just been working with that
code a little and the alternate location with environment variables is
totally broken. Even if you could ever manage to create a database that
way (which you can't), you'll never be able to drop it cleanly either.
I'll submitt a corrected version of this for the next release.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/ Sweden
************