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

[bijoy <bijoy(dot)franco(at)gmail(dot)com>]

Hi,

I am able to create database, table, etc...
But when i connect database through python program, I need to pass Username
and Passwrd along with the function, pgdb.connect().

by default, postgres is created as user. But i couldnt figure out the
password for the same

Thanks in advance

Bijoy


On Mon, Mar 30, 2009 at 10:09 PM, Lennin Caro <lennin(dot)caro(at)yahoo(dot)com> wrote:

>
> > From: bijoy <bijoy(dot)franco(at)gmail(dot)com>
> > Subject: Re: [NOVICE] createdb: could not connect to database postgres:
> FATAL:  Ident authentication failed for user "root" error
> > To: pgsql-novice(at)postgresql(dot)org, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> > Date: Monday, March 30, 2009, 3:57 PM
> > Hi,
> >
> > How to find out superuser 'postgres' password. How
> > to change the password
> >
> > Thanks in advance
> >
> > Bijoy
> >
> >
> > On Sat, Mar 28, 2009 at 10:45 PM, Tom Lane
> > <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >
> > > 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
> > >
>
>
> the postgres user exist in your OS?
> with root account try
>
> #su - postgres
>
> then use the command creatdb
>
>
>
>