pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database authentication and configuration
3+ messages / 3 participants
[nested] [flat]

* Database authentication and configuration
@ 2000-07-18 02:01 Carolyn Lu Wong <carolyn@kss.net.au>
  2000-07-18 21:45 ` Re: Database authentication and configuration Peter Eisentraut <peter_e@gmx.net>
  2000-07-19 21:46 ` Re: Database authentication and configuration Rodger Donaldson <rodgerd@diaspora.gen.nz>
  0 siblings, 2 replies; 3+ messages in thread

From: Carolyn Lu Wong @ 2000-07-18 02:01 UTC (permalink / raw)
  To: pgsql-sql

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?

In addition, I'd like to default various database settings when I
connect to the database. Where is the place to do such configuration?

TIA.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Database authentication and configuration
  2000-07-18 02:01 Database authentication and configuration Carolyn Lu Wong <carolyn@kss.net.au>
@ 2000-07-18 21:45 ` Peter Eisentraut <peter_e@gmx.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2000-07-18 21:45 UTC (permalink / raw)
  To: Carolyn Lu Wong <carolyn@kss.net.au>; +Cc: pgsql-sql

Carolyn Lu Wong writes:

> 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?

psql from 7.0 and later should automatically ask for a password if one is
required.

> In addition, I'd like to default various database settings when I
> connect to the database. Where is the place to do such configuration?

That depends on the nature of the various settings. You can put commands
into ~/.psqlrc that will be executed when psql starts up.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Database authentication and configuration
  2000-07-18 02:01 Database authentication and configuration Carolyn Lu Wong <carolyn@kss.net.au>
@ 2000-07-19 21:46 ` Rodger Donaldson <rodgerd@diaspora.gen.nz>
  1 sibling, 0 replies; 3+ messages in thread

From: Rodger Donaldson @ 2000-07-19 21:46 UTC (permalink / raw)
  To: 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@diaspora.gen.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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-07-19 21:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-18 02:01 Database authentication and configuration Carolyn Lu Wong <carolyn@kss.net.au>
2000-07-18 21:45 ` Peter Eisentraut <peter_e@gmx.net>
2000-07-19 21:46 ` Rodger Donaldson <rodgerd@diaspora.gen.nz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox