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

createuser problem in 7.3.4 on Linux

From: Paul Power <paulp127(at)dublin(dot)ie>
To: pgsql-admin(at)postgresql(dot)org
Subject: createuser problem in 7.3.4 on Linux
Date: 2003-12-17 08:39:49
Message-ID: T668fc00344c22e0851584@ESWEEPOUT1.nevadatele.com (view raw or flat)
Thread:
Lists: pgsql-admin
I have been following the basic install process for Linux.<BR>
<BR>
As user postgres I have run initdb. I create a user named Administrator via the createuser script. All goes well and I get the response CREATE USER.<BR>
Then I try: <BR>
<BR>
psql -U Administrator template1<BR>
<BR>
and get the response:<BR>
psql: FATAL: IDENT authentication failed for user "Administrator".<BR>
<BR>
<BR>
The user Administrator is however in table pg_shadow.<BR>
<BR>
But if I try DROP USER Administrator&nbsp;&nbsp;I get<BR>
<BR>
ERROR: DROP USER: user "administrator" does not exist<BR>
<BR>
Note the last error has "administrator" rather than "Administrator".<BR>
<BR>
Does anybody have any idea what is happening? If not, does anybody know if it is possible to undo the initdb, so that I can create a new Linux user Administrator and use it to create the database via initdb?<BR>
<BR>
<BR>
<BR>
Any help will be much appreciated,<BR>
Paul Power <BR>
Planitas <BR>
Swords <BR>
Ireland <BR>
---- Msg sent via Dublin WebMail - http://www.dublin.ie/ <BR><hr>Msg sent via Dublin WebMail - http://www.dublin.ie/
<CODE><FONT SIZE=3><BR>
<BR>
------------------------------------------------------------------------------------------<BR>
This email was checked by TrustMail. For more information on TrustMail, contact details can be found at www.energis.com .This email and any attachments may be confidential and the subject of legal professional privilege.  Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. The views expressed within are those of the individual and not necessarily those of the company.<BR>
Please notify the Sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium.<BR>
------------------------------------------------------------------------------------------<BR>
</FONT></CODE>


Attachment: unknown_filename
Description: text/html (1.9 KB)

Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2003-12-17 10:26:03
Subject: Re: createuser problem in 7.3.4 on Linux
Previous:From: Tom LaneDate: 2003-12-17 08:02:18
Subject: Re: character type modification

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