X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 659569DC81F for ; Wed, 8 Feb 2006 20:43:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94166-05 for ; Wed, 8 Feb 2006 20:43:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3CE6B9DCC78 for ; Wed, 8 Feb 2006 20:43:13 -0400 (AST) 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 k190h7ew020161; Wed, 8 Feb 2006 19:43:07 -0500 (EST) To: "Atul Shah" cc: pgsql-admin@postgresql.org Subject: Re: db user named 'root' In-reply-to: References: Comments: In-reply-to "Atul Shah" message dated "Wed, 08 Feb 2006 17:18:54 -0700" Date: Wed, 08 Feb 2006 19:43:07 -0500 Message-ID: <20160.1139445787@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200602/88 X-Sequence-Number: 20509 "Atul Shah" writes: > As postgres (db superuser): > createuser -s -d root > CREATE ROLE > su root > createdb root_db > createdb: could not connect to database template1: FATAL: user "root" > does not exist Works for me. Are you sure that you are talking to the same postmaster in both cases? It's possible that root and postgres have different PATH settings or different PGPORT settings or some such. > Huntsman Cancer Institute wishes to promote open communication while = > protecting confidential and/or privileged information. If you have = > received this message in error, please inform the sender and delete all = > copies. You do realize how silly you look with this sort of mumbo-jumbo attached to mail to an open mailing list, don't you? Even for private mail, do your lawyers actually think that this accomplishes anything except wasting people's disk space? regards, tom lane