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