Re: [GENERAL] can't createdb with my new user

2007-11-30 Thread Usama Dar
On 11/28/07, della <[EMAIL PROTECTED]> wrote: > > hi, I describe my steps: > > 1. installed postgresql 8.2 via apt-get (ubuntu gutsy) > 2. # sudo -u postgres psql template1 > 3. template1=# CREATE ROLE kokomo WITH LOGIN CREATEDB PASSWORD > 'kokomo'; > 4. template1=# \q > 5. # createdb kokomo_dev -U

Re: [GENERAL] can't createdb with my new user

2007-11-29 Thread Raymond O'Donnell
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