Re: template1 - recreate - Mailing list pgsql-sql

From Josh Berkus
Subject Re: template1 - recreate
Date
Msg-id 200206171147.03221.josh@agliodbs.com
Whole thread Raw
In response to template1 - recreate  (Rudi Starcevic <rudi@oasis.net.au>)
List pgsql-sql
Rudi,

> I've been searching without joy so far so I thought I'd ask.
> I know I can re-create 'template1'.
> I need to do this as I've messed up the current template1 - Oops !
>
> Fortunately Postgresql make's backups so easy no data is lost or corrupted.
>
> What's the simple command to create 'template1' from 'template0' ?

There is no simple command.  Please see my article on Techdocs:
http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php

Good luck.


--
-Josh Berkus



pgsql-sql by date:

Previous
From: Jeff Boes
Date:
Subject: Re: Limiting database size
Next
From: Josh Berkus
Date:
Subject: Request for builtin function: Double_quote