Re: password setting for a user

Lists: pgsql-docs
From: vartul_arora(at)yahoo(dot)co(dot)in (Mack Stevenson)
To: pgsql-docs(at)postgresql(dot)org
Subject: password setting for a user
Date: 2003-05-09 05:53:21
Message-ID: c9f6c60b.0305082153.7d1dbd0b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-docs

Hi! All

I am a new bie in Linux(8.0) and Postgresql 7.2. I have managed to get
my postmaster running. I have also created a database and a user for
myself. But the only thing that is NOT proper is that IT NEVER ASKS ME
FOR A PASSWORD. I am able to log in without a password!!!!!

I tried to alter the user with PASSWORD option but it just does not
work.

Any help is appreciated

Vartul


From: Richard Huxton <dev(at)archonet(dot)com>
To: vartul_arora(at)yahoo(dot)co(dot)in (Mack Stevenson), pgsql-docs(at)postgresql(dot)org
Subject: Re: password setting for a user
Date: 2003-05-16 17:15:51
Message-ID: 200305161815.51612.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-docs

On Friday 09 May 2003 6:53 am, Mack Stevenson wrote:
> Hi! All
>
> I am a new bie in Linux(8.0) and Postgresql 7.2. I have managed to get
> my postmaster running. I have also created a database and a user for
> myself. But the only thing that is NOT proper is that IT NEVER ASKS ME
> FOR A PASSWORD. I am able to log in without a password!!!!!
>
> I tried to alter the user with PASSWORD option but it just does not
> work.
>
> Any help is appreciated

Look for a pg_hba.conf file this defines Host Based Access settings which
decide whether you trust a particular host, use identd, passwords or some
other method. The file is in your .../data folder with postgresql.conf etc.

--
Richard Huxton