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 BD78CD1B1CE for ; Thu, 3 Jun 2004 09:23:56 -0300 (ADT) 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 15671-04 for ; Thu, 3 Jun 2004 12:23:59 +0000 (GMT) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 7A82BD1B1CF for ; Thu, 3 Jun 2004 09:23:54 -0300 (ADT) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004)) id <0HYQ00F01FJWBC@ndl1mr1-a-fixed.sancharnet.in> (original mail from sank89@sancharnet.in) for pgsql-admin@postgresql.org; Thu, 03 Jun 2004 17:53:55 +0530 (IST) Received: from [61.0.95.100] by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004)) with ESMTPA id <0HYQ0017CFRSLV@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Thu, 03 Jun 2004 17:53:55 +0530 (IST) Date: Thu, 03 Jun 2004 17:51:35 +0530 From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]" Subject: Re: pgsql initial superuser In-reply-to: <4030FCBF.2020005@netvisao.pt> To: pgsql-admin@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <40BF17CF.50405@sancharnet.in> Organization: Sai Hertz And Control Systems Pvt Ltd MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) References: <4030FCBF.2020005@netvisao.pt> X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/22 X-Sequence-Number: 13682 Dear Pedro , > Hello. this is my "first" time using pgsql, and I seem to be running > to a bit of a corner here :-) > > I've understood how to add a superuser/database-user/user but I have > no user to begin with. > > ~# createuser superuser > 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) y > psql: FATAL: user "root" does not exist > createuser: creation of user "superuser" failed > If you have compiled PostgreSQL then the user login used for initdb is the default user else this was from rpm then postgres is the super user you may login as psql -U postgres template1 -- Regards, Vishal Kashyap Director / Lead Software Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Jabber IM: vishalkashyap[ a t ]jabber.org ICQ : 264360076 Yahoo IM: mailforvishal[ a t ]yahoo.com ----------------------------------------------- You yourself, as much as anybody in the entire universe, deserve your love and affection. - Buddha --------------- pgsql=# select marital_status from vishals_life; marital_status ------------------ Single not looking 1 Row(s) affected