Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id BF65B475862 for ; Wed, 3 Apr 2002 20:58:26 -0500 (EST) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.2) with HTTP id 847087; Wed, 03 Apr 2002 17:58:28 -0800 From: "Josh Berkus" Subject: Re: Cleaning up template 1 -> template0 cloning To: Thomas Good , Josh Berkus Cc: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.5.2 Date: Wed, 03 Apr 2002 17:58:28 -0800 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200204/45 X-Sequence-Number: 7310 Folks, > Help! The above documentation seems to be incorrect. Sorry about the panic, here. It turns out that it is possible to do as suggested to restore template1, provided that one is prepared to manipulate the datallowconn and datistemplate flags in template0 and template1. Template1 is restored. E-mail me if any of you ever have to do the same. In fact, I'll write it up ... -Josh Berkus