Stephen Frost <[email protected]> writes:
> * Matt Landry ([email protected]) wrote:
>> postgres=# select datname, datallowconn from pg_database ;
>> datname | datallowconn
>> -----------+--------------
>> template1 | t
>> template0 | t
>> postgres | t
>> reporting | t
>> (4 rows)
> Right, as I mentioned, template0 shouldn't have datallowconn as 'true'.
> That's why it's being included in the pg_dumpall.
Perhaps pg_upgrade should deliberately ignore template0 regardless of
datallowconn? And/or we should hard-wire that into pg_dumpall?
I feel no compulsion whatsoever to preserve any user-initiated changes
in template0 across an upgrade.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
