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
Re: createuser problem in 7.3.4 on Linux |
Список | 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 по дате отправления: