Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group