Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error


  • From: Aarni <aarni(at)kymi(dot)com>
  • To: pgsql-novice(at)postgresql(dot)org
  • Cc: bijoy <bijoy(dot)franco(at)gmail(dot)com>
  • Subject: Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error
  • Date: Sat, 28 Mar 2009 14:26:19 +0200
  • Message-id: <200903281426.20362.aarni@kymi.com> <text/plain>

On Saturday 28 March 2009 13:08:27 bijoy wrote:
> Hi,
>
> i am new to database postgresql.
>
> when i tried creating database using 'createdb', following error occuered.
> createdb mydb
> createdb: could not connect to database postgres: FATAL:  Ident
> authentication failed for user "root"
>
> What would be the reason.
>
> Thanks in advance
>
> bijoy

Hi,

Root can not run postgres. You must initdb, createdb, pg_ctl etc. as user 
'postgres', the database super user and owner, or as some other user who has 
sufficient rights to do such things.

Best regards,
-- 
Aarni Ruuhimäki



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group