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