From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <gsstark(at)mit(dot)edu>, Dave Page <dpage(at)pgadmin(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: template0 database comment |
Date: | 2011-03-15 15:51:49 |
Message-ID: | AANLkTi=RVH02aetif+_MYQ4Vw6u2qSbaTSph0pcWoZgO@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 15 March 2011 15:37, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Thom Brown wrote:
>> On 15 March 2011 15:26, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> >
>> > Applied. ?I did not bump the catalog version because they are just
>> > comments. ?I assume that is the right procedure.
>>
>> *SNIP*
>>
>> >> + ? ? ? ? ? ? "COMMENT ON DATABASE postgres IS 'default administrative connection database';\n",
>>
>> Default administrative connection database? Where's the "connection"
>> bit come from?
>
> There was discussion that 'postgres' is the database that is used for
> performing administrative connections, e.g. createdb. Yeah, kind of
> odd, but that's what it is used for.
Hmm... there's actually no mention of that in the docs for such tools:
http://www.postgresql.org/docs/9.0/static/app-createdb.html
There's also little mention of this "administrative" database in the
docs beyond saying it's merely a copy of template1 used as a default
database for users and applications to connect to.
I also notice there's no choice but to use the "postgres" database
with these tools. Shouldn't we have an option that allows us to
specify an alternative database?
e.g.
createdb -d alternativedb newdb
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-03-15 16:09:47 | Re: dependency between numbers keywords and parser speed |
Previous Message | Tom Lane | 2011-03-15 15:46:15 | Re: Re: [COMMITTERS] pgsql: Add missing keywords to gram.y's unreserved_keywords list. |