------=_Part_17730_1772127.1150639693291
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

[root@localhost ~]# createuser -a -d -e antonio
createuser: could not connect to database template1: FATAL: user "root"
does not exist
[root@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.

--
Regards
Vinayak Mutalikdesai
9845301581

------=_Part_17730_1772127.1150639693291
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

[root@localhost ~]# createuser -a -d -e antonio<br>
createuser: could not connect to database template1: FATAL:&nbsp; user &quot;root&quot; does not exist<br>
[root@localhost ~]#<br>
<br>
i logged in as root..<br>
I tried to create a new user i am getting this error message...<br>
Kindly look in to this matter.<br clear="all"><br>-- <br>Regards <br>Vinayak Mutalikdesai<br>9845301581

------=_Part_17730_1772127.1150639693291--

--zhXaljGHf11kAtnf
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Sun, Jun 18, 2006 at 07:38:13PM +0530, vinayak Desai wrote:
This is not a bug. It's just that root is not a known database user.
Typically there is an user postgres with full admin rights, so as root,
do

su - postgres

and then try crateuser, etc.

HTH
-- toms

--zhXaljGHf11kAtnf
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFEmm/fBcgs9XrR2kYRAhePAJ99nwsMR56+6Ba/vo+MiETfD4G4uACeJ5A/
w1Y9447oRnYYXQE3rJ2SCzU=
=N0tq
-----END PGP SIGNATURE-----

--zhXaljGHf11kAtnf--

On Sun, Jun 18, 2006 at 07:38:13PM +0530, vinayak Desai wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org