pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase 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>
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 21:45 Peter Eisentraut <peter_e@gmx.net>
parent: Carolyn Lu Wong <carolyn@kss.net.au>
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-19 21:46 Rodger Donaldson <rodgerd@diaspora.gen.nz>
parent: Carolyn Lu Wong <carolyn@kss.net.au>
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