I have been following the basic install process for Linux.
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.
Then I try:
psql -U Administrator template1
and get the response:
psql: FATAL: IDENT authentication failed for user "Administrator".
The user Administrator is however in table pg_shadow.
But if I try DROP USER Administrator I get
ERROR: DROP USER: user "administrator" does not exist
Note the last error has "administrator" rather than "Administrator".
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?
Any help will be much appreciated,
Paul Power
Planitas
Swords
Ireland
---- Msg sent via Dublin WebMail - http://www.dublin.ie/
Msg sent via Dublin WebMail - http://www.dublin.ie/
------------------------------------------------------------------------------------------
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.
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.
------------------------------------------------------------------------------------------