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@xxxxxx --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
