Re: pg_upgrade if 'postgres' database is dropped - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_upgrade if 'postgres' database is dropped
Date
Msg-id 201110280240.p9S2eP527985@momjian.us
Whole thread Raw
In response to Re: pg_upgrade if 'postgres' database is dropped  (Stephen Frost <sfrost@snowman.net>)
Responses Re: pg_upgrade if 'postgres' database is dropped  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen Frost wrote:
-- Start of PGP signed section.
> * Bruce Momjian (bruce@momjian.us) wrote:
> > So, it is going to be confusing to support both databases because there
> > is the cleanup details I have to document if I use template1.
> 
> Presumably there's some other database in the system besides template1
> if postgres doesn't exist..  Would it be possible to just make it
> configurable?  Then the user could pick a non-template database.  Having
> it fail if the option isn't used and the default postgres isn't there is
> fine, imv.

I have not seen enough demand to make this a user-visible configuration.
We can just tell them to create a postgres database.   Frankly, they
would have had to _remove_ the postgres database after initdb for it not
to be there, and they are instructed to change nothing about the new
database.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_upgrade if 'postgres' database is dropped
Next
From: Stephen Frost
Date:
Subject: Re: pg_upgrade if 'postgres' database is dropped