Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 69E2F475A70 for ; Mon, 17 Jun 2002 02:16:32 -0400 (EDT) Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id 0F57E475903 for ; Mon, 17 Jun 2002 02:16:30 -0400 (EDT) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/100.1) with ESMTP id QAA18864 for ; Mon, 17 Jun 2002 16:25:13 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3D0D7F16.9000408@oasis.net.au> Date: Mon, 17 Jun 2002 16:17:58 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0rc2) Gecko/20020510 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: template1 - recreate Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/214 X-Sequence-Number: 8179 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.