Eimantas =?utf-8?q?Vai=C4=8Di=C5=ABnas?= <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org