Re: Error on createuser

From: Klaus Ita <ita(at)ai(dot)wu-wien(dot)ac(dot)at>
To: vinayak Desai <vinayak(dot)mdesai(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Error on createuser
Date: 2006-06-22 06:23:07
Message-ID: 20060622062306.GK26915@aipc54.ai.wu-wien.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Jun 18, 2006 at 07:38:13PM +0530, vinayak Desai wrote:
> [root(at)localhost ~]# createuser -a -d -e antonio
> createuser: could not connect to database template1: FATAL: user "root"
> does not exist
> [root(at)localhost ~]#
>
> i logged in as root..
> I tried to create a new user i am getting this error message...
> Kindly look in to this matter.
>

root is not automatically permitted to do so. you might want to read up the
permission part of the manual. try as the user owning the cluster (on my
system that is postmaster)

su postmaster -- createuser ....

regs,
klaus

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-06-22 06:59:08 BUG #2490: '||' and type casting for user defined types
Previous Message James A Cole 2006-06-21 17:08:38 BUG #2489: Metadata dosen't match tables