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 32EC93A5657 for ; Tue, 16 Nov 2004 05:41:19 +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 87458-03 for ; Tue, 16 Nov 2004 05:41:08 +0000 (GMT) Received: from webdata.ibma.org.ph (unknown [61.9.47.201]) by svr1.postgresql.org (Postfix) with ESMTP id 6FCDC3A563F for ; Tue, 16 Nov 2004 05:41:05 +0000 (GMT) Received: from webdata.ibma.org.ph (webdata.ibma.org.ph [127.0.0.1]) by webdata.ibma.org.ph (8.12.10/8.12.10) with ESMTP id iAG5tUuD005984 for ; Tue, 16 Nov 2004 13:55:31 +0800 Received: (from apache@localhost) by webdata.ibma.org.ph (8.12.10/8.12.10/Submit) id iAG5tUpP005982; Tue, 16 Nov 2004 13:55:30 +0800 X-Authentication-Warning: webdata.ibma.org.ph: apache set sender to jeoff@ibma.org.ph using -f Received: from 61.9.47.201 (proxying for unknown) (SquirrelMail authenticated user jeoff); by www.ibma.org.ph with HTTP; Tue, 16 Nov 2004 13:55:30 +0800 (PHT) Message-ID: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201> Date: Tue, 16 Nov 2004 13:55:30 +0800 (PHT) Subject: psql: FATAL: user "root" does not exist createdb: database creation failed From: "Jeoffrey L. Palacio" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.3a-0.f1.1 X-Mailer: SquirrelMail/1.4.3a-0.f1.1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal 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/138 X-Sequence-Number: 15522 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