Thread: 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