On 28/11/2007 14:02, della wrote:
createdb: could not connect to database postgres: FATAL: Ident
authentication failed for user "kokomo"
So, given that I do not fail submitting the password for kokomo when
requested... what could be the problem? Have I to create a system user
for kokomo?
If I use pgadmin3 I see the kokomo user with it own encrypted password
and I can create the DB with kokomo as a owner. So what am I missing
in the command line?
Have a look at the docs for the various client authentication
mechanisms, and particularly the pg_hba.conf file.....you need to add a
line to it requiring a password for your new user and the host from
which it is connecting.
http://www.postgresql.org/docs/8.2/interactive/client-authentication.html
HTH,
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
