Re: [SQL] Database authentication and configuration

2000-07-19 Thread Rodger Donaldson
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

Re: [SQL] Database authentication and configuration

2000-07-18 Thread Peter Eisentraut
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

[SQL] Database authentication and configuration

2000-07-17 Thread Carolyn Lu Wong
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?