pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
template1 - recreate
2+ messages / 2 participants
[nested] [flat]

* template1 - recreate
@ 2002-06-17 06:17 Rudi Starcevic <rudi@oasis.net.au>
  2002-06-17 18:47 ` Re: template1 - recreate Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Rudi Starcevic @ 2002-06-17 06:17 UTC (permalink / raw)
  To: pgsql-sql

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.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: template1 - recreate
  2002-06-17 06:17 template1 - recreate Rudi Starcevic <rudi@oasis.net.au>
@ 2002-06-17 18:47 ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2002-06-17 18:47 UTC (permalink / raw)
  To: Rudi Starcevic <rudi@oasis.net.au>; 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-06-17 18:47 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-17 06:17 template1 - recreate Rudi Starcevic <rudi@oasis.net.au>
2002-06-17 18:47 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox