On 15 March 2011 15:51, Thom Brown <t...@linux.com> wrote: > On 15 March 2011 15:37, Bruce Momjian <br...@momjian.us> wrote: >> Thom Brown wrote: >>> On 15 March 2011 15:26, Bruce Momjian <br...@momjian.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. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
createdb_db_opt.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
