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 EE0383A3F24 for ; Wed, 17 Nov 2004 13:54:04 +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 72426-02 for ; Wed, 17 Nov 2004 13:53:55 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.207]) by svr1.postgresql.org (Postfix) with ESMTP id 55A2E3A3EE1 for ; Wed, 17 Nov 2004 13:53:57 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 70so564631wra for ; Wed, 17 Nov 2004 05:53:58 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=L25mCbQ0/jHzn8GYjM+jkNd5dDH54tGgYmyazFy3XwuFTVAwYT+tiCfHp/kx4pLYq9+JaaKc75pT7JOuWsm0pepY7yuhBpivSiBiHtS0jJHkKpHqQq/ku6+tjdW7fCmA4QAsVLUAWOEATbadZayLDwWqdZReLGN2JQrGw5sEPOg= Received: by 10.54.18.22 with SMTP id 22mr673881wrr; Wed, 17 Nov 2004 05:53:58 -0800 (PST) Received: by 10.54.50.36 with HTTP; Wed, 17 Nov 2004 05:53:58 -0800 (PST) Message-ID: <77b69d210411170553319b260f@mail.gmail.com> Date: Wed, 17 Nov 2004 19:23:58 +0530 From: "Vishal Kashyap @ [SaiHertz]" Reply-To: "Vishal Kashyap @ [SaiHertz]" To: "Jeoffrey L. Palacio" Subject: Re: psql: FATAL: user "root" does not exist createdb: database creation failed Cc: pgsql-admin@postgresql.org In-Reply-To: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/147 X-Sequence-Number: 15531 Try this createdb -U postgres ibmadb On Tue, 16 Nov 2004 13:55:30 +0800 (PHT), 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 > -- With Best Regards, Vishal Kashyap. Did you know SaiPACS is one and only PACS Management tool. http://saihertz.com, http://vishalkashyap.tk