Skip site navigation (1) Skip section navigation (2)

Re: password setting for a user

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 (view raw or flat)
Thread:
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

In response to

pgsql-docs by date

Next:From: ahowardDate: 2003-05-20 19:13:29
Subject: pam-linux, /etc/shadow : HOW-TO
Previous:From: Viktor VislobokovDate: 2003-05-14 09:14:14
Subject: Updated version of Russian FAQ

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group