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: (view raw, whole thread or download thread mbox)
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

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-2017 The PostgreSQL Global Development Group