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

Re: Database authentication and configuration

From: Rodger Donaldson <rodgerd(at)diaspora(dot)gen(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Database authentication and configuration
Date: 2000-07-19 21:46:43
Message-ID: 20000720094643.A32547@diaspora.gen.nz (view raw or flat)
Thread:
Lists: pgsql-sql
On Tue, Jul 18, 2000 at 12:01:46PM +1000, Carolyn Lu Wong wrote:

> Are there anywhere to configure so that whenever I call 'psql dbname',
> it'll always prompt for user authentication instead of getting into the
> database directly?

Take a look at the configuration of your pg_hba.conf file.  You will most
likely find that you're set up to trust local users.  You can force
authentication by changing this to password, crypt, or kerberos based
authentication.

-- 
Rodger Donaldson		rodgerd(at)diaspora(dot)gen(dot)nz
"Forgive us if we bite your head off; we were led to assume you weren't
using it in the first place"
		--Jim Allenspach, in comp.lang.perl.misc

In response to

pgsql-sql by date

Next:From: Bernie HuangDate: 2000-07-20 00:25:59
Subject: Order by in Select
Previous:From: Tom LaneDate: 2000-07-19 18:21:58
Subject: Re: Can I create a function that returns many records?

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