Re: template0 database comment

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Thom Brown <thom(at)linux(dot)com>
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 18:36:52
Message-ID: 201103151836.p2FIaq721481@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thom Brown wrote:
> On 15 March 2011 15:51, Thom Brown <thom(at)linux(dot)com> wrote:
> > 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
>
> And example patch attached.

We have actually never gotten a request for this so it is hard to see
why we would add it.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2011-03-15 18:44:30 Re: why is max standby delay only 35 minutes?
Previous Message David Fetter 2011-03-15 18:02:36 Re: template0 database comment