Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error - Mailing list pgsql-novice

From Aarni
Subject Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error
Date
Msg-id 200903281426.20362.aarni@kymi.com
Whole thread Raw
In response to createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error  (bijoy <bijoy.franco@gmail.com>)
List pgsql-novice

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

pgsql-novice by date:

Previous
From: bijoy
Date:
Subject: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error
Next
From: Tom Lane
Date:
Subject: Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error