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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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 Content-Type Size
unknown_filename text/html 1.9 KB

Responses

Browse pgsql-admin by date

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