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. +
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 |