Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: vartul_arora@yahoo.co.in (Mack Stevenson),
	pgsql-docs@postgresql.org
Subject: Re: password setting for a user
Date: Fri, 16 May 2003 18:15:51 +0100
User-Agent: KMail/1.4.3
References: <c9f6c60b.0305082153.7d1dbd0b@posting.google.com>
In-Reply-To: <c9f6c60b.0305082153.7d1dbd0b@posting.google.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200305161815.51612.dev@archonet.com>

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=
=20
decide whether you trust a particular host, use identd, passwords or some=
=20
other method. The file is in your .../data folder with postgresql.conf etc.

--=20
  Richard Huxton