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

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