X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4D33D5640D for ; Thu, 10 Mar 2005 06:36:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02745-10 for ; Thu, 10 Mar 2005 06:36:29 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3F0455645E for ; Thu, 10 Mar 2005 06:36:28 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2A6aT1a011881; Thu, 10 Mar 2005 01:36:29 -0500 (EST) To: eimantas.vaiciunas@sc.vu.lt Cc: pgsql-admin@postgresql.org Subject: Re: template1 database In-reply-to: <200503100817.03215.eimantas.vaiciunas@sc.vu.lt> References: <200503100817.03215.eimantas.vaiciunas@sc.vu.lt> Comments: In-reply-to Eimantas =?utf-8?q?Vai=C4=8Di=C5=ABnas?= message dated "Thu, 10 Mar 2005 08:17:03 +0000" Date: Thu, 10 Mar 2005 01:36:29 -0500 Message-ID: <11880.1110436589@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/144 X-Sequence-Number: 16642 Eimantas =?utf-8?q?Vai=C4=8Di=C5=ABnas?= writes: > Just been wondering how important is template1 database to PgSQL? The database server itself doesn't care, but there are enough client-side tools that assume template1 exists that you would not find life pleasant if you do this. > What would happen if i drop this database together with postgres user. The root user does not have to be named "postgres", but you do have to have a root user. What exactly do you think will be accomplished by removing the postgres user? If you are just idly searching for ways to break your database, try removing some of the builtin datatypes from pg_type, or builtin functions from pg_proc, etc ... regards, tom lane