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 AC1143A3EE2 for ; Tue, 16 Nov 2004 20:17:21 +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 76376-10 for ; Tue, 16 Nov 2004 20:17:06 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id 4D1973A3F33 for ; Tue, 16 Nov 2004 20:17:06 +0000 (GMT) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.12.11/8.12.8) with ESMTP id iAGKH2JU005688; Tue, 16 Nov 2004 15:17:02 -0500 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id iAGKH21V005685; Tue, 16 Nov 2004 15:17:02 -0500 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Tue, 16 Nov 2004 15:17:02 -0500 (EST) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: "Jeoffrey L. Palacio" Cc: pgsql-admin@postgresql.org Subject: Re: psql: FATAL: user "root" does not exist createdb: In-Reply-To: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201> Message-ID: References: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=SUBJ_HAS_SPACES X-Spam-Level: X-Archive-Number: 200411/140 X-Sequence-Number: 15524 execute these as the postgres user: su - postgres One option is to create a super-user with something like: postgres$ createuser -d -a -P jeoff then: jeoff$ createdb ibmadb then do administrative things with that user. I would advise *NOT* using root. If this is a tightly controlled (non-shared) machine, you could make a super user as your normal unix login (which hopefull is not root). Ideally you'll only need root to start the postgres service. On Tue, 16 Nov 2004, Jeoffrey L. Palacio wrote: > > > Hi to all I'm Jeoffrey, and I'm a newbie to postgreSQL. My problem is > that when i execute the command createdb i always get a > > [root@webdata root]# createdb ibmadb > psql: FATAL: user "root" does not exist > createdb: database creation failed > > Then I tried to create the user root by the command: > > createuser and i always get this message also: > > [root@webdata root]# createuser > Enter name of user to add: root > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new users? (y/n) n > psql: FATAL: user "root" does not exist > createuser: creation of user "root" failed > > > my postgresql version is 7.3.4 and my OS is FEDORA CORE 1 x86_64 bit > architecture. > > What is wrong about it? please help. > > > Thanks, > > Jeoffrey > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > [ \ / [ >X< Christian Fowler | spider AT viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org