Обсуждение: template1 - recreate

Hello friends,

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' ?

Thanks heaps in advance.

Best Regards
Rudi Starcevic.

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