Re: can't createdb with my new user

[Raymond O'Donnell <rod(at)iol(dot)ie>]

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
rod(at)iol(dot)ie
---------------------------------------------------------------