Thread: Database authentication and configuration
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.
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
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