Re: template1 - recreate

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>, pgsql-sql(at)postgresql(dot)org
Subject: Re: template1 - recreate
Date: 2002-06-17 18:47:03
Message-ID: 200206171147.03221.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-06-17 20:34:01 Request for builtin function: Double_quote
Previous Message Jeff Boes 2002-06-17 16:52:47 Re: Limiting database size