From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-sql@postgreSQL.org
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [SQL] createdb -D xxxx not working
Date: Tue, 11 Jan 2000 10:14:10 -0500
Message-ID: <4279.947603650@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.21.0001110112121.7876-100000@localhost.localdomain>
References: <Pine.LNX.4.21.0001110112121.7876-100000@localhost.localdomain>
[hackers added to cc: list]
Peter Eisentraut <peter_e@gmx.net> writes:
> On 2000-01-08, Tom Lane mentioned:
>> Chris Griffin <cgriffin@websales.com> writes:
>>>> # setenv PGDATA2 /web/sites/1.192/db-data
>>>> # initlocation PGDATA2
>>>> # createdb -D PGDATA2
>>
>> Surely you want $PGDATA2 in the latter two lines?
> You might recall me mentioning that the whole alternative location
> business doesn't work in the first place. I'll fix that this week; Chris
> will have to wait until the next release.
Fine. BTW, am I the only one who thinks that it's really silly for
initlocation to expect to be given an unexpanded environment variable
name? That's not normal practice (either elsewhere in Postgres, or
anywhere else that I know of). It's confusing because it's not how
an ordinary Unix user would expect a shell command to behave, and it
doesn't buy any functionality that I can see. I'd vote for taking
out the auto-expansion, so that the correct invocation becomes
initlocation $PGDATA2
which is what an average user would expect.
Actually, after looking at what initlocation really does, which is
darn near nothing, I wonder whether we shouldn't dispense with it
altogether...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, peter_e@gmx.net, pgsql-hackers@postgreSQL.org
Subject: Re: [SQL] createdb -D xxxx not working
In-Reply-To: <4279.947603650@sss.pgh.pa.us>
References: <Pine.LNX.4.21.0001110112121.7876-100000@localhost.localdomain> <4279.947603650@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox