Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Kenji Morishige wrote:
>> I've been stumped as to how to call psql from the command line without it
>> prompting me for a password. Is there a enviornoment variable I can specify
>> for
>> the password or something I can place in .pgsql? I could write a perl
>> wrapper
>> around it, but I've been wondering how I can call psql -c without it
>> prompting
>> me. Is it possible?
> Sure it is. Set up a .pgpass file.
Also, consider whether a non-password-based auth method (eg, ident)
might work for you. Personally, I wouldn't trust ident over TCP, but
if your kernel supports it on unix-socket connections it is secure.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
