Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 1E4078E352A
	for <pgsql-admin@postgresql.org>; Sat,  3 Mar 2012 18:28:54 -0400 (AST)
Received: from locust.cns.vt.edu ([198.82.169.14])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <stellr@cns.vt.edu>) id 1S3xRY-0003da-DN
	for pgsql-admin@postgresql.org; Sat, 03 Mar 2012 22:28:54 +0000
Received: by locust.cns.vt.edu (Postfix, from userid 986)
	id 10F03118DE6; Sat,  3 Mar 2012 17:28:04 -0500 (EST)
Date: Sat, 3 Mar 2012 17:28:04 -0500
From: Ray Stell <stellr@cns.vt.edu>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: re-create information_schema
Message-ID: <20120303222804.GA25365@cns.vt.edu>
References: <20120229205513.GA761@cns.vt.edu>
 <20120229212501.GB761@cns.vt.edu>
	<1330799239.11007.7.camel@vanquo.pezone.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1330799239.11007.7.camel@vanquo.pezone.net>
User-Agent: Mutt/1.5.17 (2007-11-01)
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201203/8
X-Sequence-Number: 39196

On Sat, Mar 03, 2012 at 08:27:19PM +0200, Peter Eisentraut wrote:
> On ons, 2012-02-29 at 16:25 -0500, Ray Stell wrote:
> > On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote:
> > > http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
> > > This must be repeated in each
> > > database to be fixed.
> > 
> > including postgres, template0, and template1?
> 
> Yes, if you want those databases to be fixed.


A trick with template0, or so it seems:

template1=# select datname, datallowconn from pg_database;
  datname  | datallowconn 
-----------+--------------
 template1 | t
 template0 | f
 postgres  | t
 rd        | t
(4 rows)