createuser problem in 7.3.4 on Linux

Поиск
Список
Период
Сортировка
От Paul Power
Тема createuser problem in 7.3.4 on Linux
Дата
Msg-id T668fc00344c22e0851584@ESWEEPOUT1.nevadatele.com
обсуждение исходный текст
Ответы Re: createuser problem in 7.3.4 on Linux  (Peter Eisentraut <peter_e@gmx.net>)
Re: createuser problem in 7.3.4 on Linux  ("A.Bhuvaneswaran" <bhuvan@symonds.net>)
Список pgsql-admin
I have been following the basic install process for Linux.<br /><br /> As user postgres I have run initdb. I create a
usernamed 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
failedfor user "Administrator".<br /><br /><br /> The user Administrator is however in table pg_shadow.<br /><br /> But
ifI try DROP USER Administrator  I get<br /><br /> ERROR: DROP USER: user "administrator" does not exist<br /><br />
Notethe 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
Administratorand 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
byTrustMail. For more information on TrustMail, contact details can be found at www.energis.com .This email and any
attachmentsmay be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying
ofthis email without the consent of the sender is strictly prohibited. The views expressed within are those of the
individualand not necessarily those of the company.<br /> Please notify the Sender immediately if you are not the
intendedrecipient and then delete the email from your inbox and do not disclose the contents to another person, use,
copyor store the information in any medium.<br />
------------------------------------------------------------------------------------------<br/></font></code> 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: character type modification
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: createuser problem in 7.3.4 on Linux