Postgres Pro
Downloads
Home   >   mailing lists

Re: Cleaning up template 1 -> template0 cloning - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Cleaning up template 1 -> template0 cloning
Date
Msg-id web-847087@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Cleaning up template 1 -> template0 cloning  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
Folks,

> Help!  The above documentation seems to be incorrect.

Sorry about the panic, here.  It turns out that it is possible to do assuggested to restore template1, provided that
oneis prepared tomanipulate the datallowconn and datistemplate flags in template0 andtemplate1.
 

Template1 is restored.  E-mail me if any of you ever have to do thesame.  In fact, I'll write it up ...

-Josh Berkus

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Cleaning up template 1 -> template0 cloning
Next
From: Tom Lane
Date:
Subject: Re: Cleaning up template 1 -> template0 cloning