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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bijoy <bijoy(dot)franco(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error
Date: 2009-03-28 17:15:50
Message-ID: 19127.1238260550@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

bijoy <bijoy(dot)franco(at)gmail(dot)com> writes:
> 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"

You didn't say whose packaging of Postgres this is, but it looks like
you're using a setup that has ident authentication selected. That
means the only user that can get in initially is user "postgres".
(Well, actually, whatever the initial superuser is, but the odds are
just about 100% that it's named "postgres".) Your first step should
probably be to create a postgres account for your regular userid
(not root), say via

su - postgres
createuser joe

If you don't want authentication to work this way, you can change the
setup in pg_hba.conf. See the manual under "Client Authentication".
If you're the only person using the machine and you're unworried about
someone cracking into it, you could just as well use "trust" mode
and not bother with restrictions.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message bijoy 2009-03-30 15:57:31 Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error
Previous Message Aarni 2009-03-28 12:26:19 Re: createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "root" error